meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327441' 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
(
)
)
ffd_listing_title, 55 Red Rock Way #204O, San Francisco, CA, 94131
ffd_mls_id, 422710077
ffd_salesforce_id, a0E8W00000a7yKSUAY
num_of_fireplaces__c, 1
num_of_rooms__c, 2
of_units__c, 396
address2__c, 55 Red Rock Way #204O, San Francisco, CA, 94131
pba__address_pb__c, 55 Red Rock Way #204O, San Francisco, CA, 94131
agent_only_remarks__c, Property was on hold status for the Holidays. Great New Price! There is no lockbox. Great value for this spacious studio with multiple closets and GREAT NATURAL LIGHT! For showing requests please contact Elizabeth Igudesman at (415) 418-8387 or Courtney Whitaker at (415) 686-2223. Full Reports, Disclosures & HOA Docs are available.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Tile;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1972
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Courtney M Whitaker
pba__contingentdate__c, 2023-02-12
ffd_createddate, 2023-01-23T19:46:00.000+0000
days_on_market__c, 233
dom__c, 61
ffd_description_pb, Incredible New Price for a Sun-Drenched Jewel in Diamond Heights Village! This fabulous, move-in-ready condo offers year-round natural light in a serene, park-like setting. Enjoy almost 600 square feet of bright living space featuring custom built-ins for home office and storage, a queen-sized Murphy bed that folds away for maximum flexibility, a crisply updated kitchen opens to a generous dining and living area anchored by a cozy, warm fireplace! This spacious studio has brand new carpet, interior paint and fixtures. Includes a deeded parking place in a secure, gated garage. Enjoy verdant sky and City views and a community abundant with trees, gardens, walking paths and even a Koi pond! Building offers an elevator, secured entrances, intercom system and a conveniently located laundry room with multiple machines. Diamond Heights Village Amenities include a community clubhouse with a beautifully-designed lounge and game room, complete fitness center, heated outdoor pool, hot tub, dry sauna and EV charging stations. Don't miss out on a unique SF Lifestyle, Location & Luxury Amenities --It's All Here at 55 Red Rock Way #O204 in Diamond Heights!
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Brick;Gas Log
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Common Areas,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Roof,Trash
pba__hoafees__c, 594
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Diamond Heights Village
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace;Fireplace(s)
ffd_lastmodifieddate, 2023-07-13T18:09:30.000+0000
pba__latitude_pb__c, 37.7460467
pba__latitude_property__c, 37.7460467
listed_date__c, 2022-11-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Elizaveta
pba__listing_agent_lastname__c, Igudesman
listing_agent_mls_id__c, 804017
ffd_listingagentname, Elizabeth Igudesman
listing_agent_number__c, 166013419
listing_co_agent_mls_id__c, A333854
listing_co_agent_number__c, 981091644
listing_co_office_mls_id__c, 7A2676
listing_co_office_name__c, Golden Gate Sotheby's International Realty
listing_co_office_number__c, 981088652
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 519000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4410617
mls_id__c, 422710077
master_property__c, a0O1I000001VhkGUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-11-28
original_price__c, 539000
overall_days_on_market__c, -81415
parking_access__c, Independent
parking_features__c, Assigned,Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-03-03
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 853.04
pba__propertytype__c, Condominium
ListingId, a0E8W00000a7yKSUAY
sale_date__c, 2023-03-10
sale_price__c, 505000
selling_agent_mls_id__c, 816587
selling_agent_number__c, 1075545
selling_co_agent_mls_id__c, 816167
selling_co_agent_number__c, 1075148
selling_co_office_mls_id__c, TWNO
selling_co_office_name__c, Twin Oaks Real Estate, Inc.
selling_co_office_number__c, 28681
selling_office_name__c, Twin Oaks Real Estate, Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 592
size__c, 592
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Red Rock
subdist__c, Diamond Heights
ffd_name, 55 Red Rock Way #204O, San Francisco, CA, 94131
view__c, Garden/Greenbelt;Twin Peaks;Hills
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1972
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530557881-1.jpg