meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='346619' 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, 1702080822
ffd_listing_title, 255 Red Rock Way #303H, San Francisco, CA, 94131
ffd_mls_id, 423918942
ffd_salesforce_id, a0E8W00000dxaiYUAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 3
of_units__c, 396
address2__c, 255 Red Rock Way #303H, San Francisco, CA, 94131
pba__address_pb__c, 255 Red Rock Way #303H, San Francisco, CA, 94131
agent_only_remarks__c, Please contact [email protected] for all showing requests. Disclosures available upon request.
appliances__c, Microwave;Disposal;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Mid-Century
bath_features__c, Tub w/Shower Over;Tile;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1972
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Isabelle Grotte
pba__contingentdate__c, 2023-11-06
cooling__c, None
ffd_createddate, 2023-11-03T20:47:42.000+0000
days_on_market__c, 35
dom__c, 18
ffd_description_pb, Discover the perfect blend of comfort and convenience at 255 Red Rock Way #303 H. This top floor, one-bedroom, one-bathroom condo is the largest one-bedroom layout on the property. Oversized windows flood the space with natural light and frame the mature trees beyond. In a private secluded corner, this residence provides a tranquil living experience with open beam ceilings, gas fireplace, maple wood kitchen cabinets, and bedroom with walk-in closet plus one car parking. Freshly painted throughout with new carpet. Enjoy the luxury of a heated swimming pool, recently renovated clubhouse, fitness room, spa and sauna, including outdoor streams and waterfalls, all within the complex. This home offers the ideal balance of a peaceful lifestyle and recreation. Commuting is a breeze with nearby public transportation options. Enjoy a short walk to Christopher Park, the grocery store, pharmacy and Post Office. The perfect getaway from the hustle and bustle of the city while being remarkably close to everything you need.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Starter;Insert
pba__floortype_pb__c, Carpet;Tile
hoa_fee_includes__c, Common Areas,Elevator,Insurance on Structure,Management,Pool,Recreation Facility,Sewer,Trash,Water
pba__hoafees__c, 688
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Diamond Heights Village
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Natural Gas
interior_features__c, Open Beam Ceiling
ffd_lastmodifieddate, 2023-12-08T23:46:37.000+0000
pba__latitude_pb__c, 37.7455863
pba__latitude_property__c, 37.7455863
laundry_features__c, Other
listed_date__c, 2023-11-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Scott
pba__listing_agent_lastname__c, Wickham
listing_agent_mls_id__c, 815077
ffd_listingagentname, Scott Wickham
listing_agent_number__c, 1070571
listing_co_agent_mls_id__c, 807863
listing_co_agent_number__c, 1027872
listing_co_office_mls_id__c, COMP41
listing_co_office_name__c, Compass
listing_co_office_number__c, 27887
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 589000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.255redrockway-303h.com/mls/119562886
pba__longitude_pb__c, -122.4430698
mls_id__c, 423918942
master_property__c, a0O1I000004VXgBUAW
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-11-03
original_price__c, 589000
overall_days_on_market__c, -81755
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-11-21
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-12-08T08:11:27.000+0000
price_per_square_foot__c, 705.25
pba__propertytype__c, Condominium
ListingId, a0E8W00000dxaiYUAQ
roof__c, Tar/Gravel
sale_date__c, 2023-12-06
sale_price__c, 591000
security_features__c, Smoke Detector;Security Gate;Fire Alarm;Secured Access;Carbon Mon Detector
selling_agent_mls_id__c, 814578
selling_agent_number__c, 1067286
selling_co_agent_mls_id__c, 803029
selling_co_agent_number__c, 803029
selling_co_office_mls_id__c, KWADVSF
selling_co_office_name__c, KW Advisors
selling_co_office_number__c, 28861
selling_office_name__c, KW Advisors
pba__status__c, Closed
pba__totalarea_pb__c, 838
size__c, 838
spa__c, 1
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Red Rock
subdist__c, Diamond Heights
ffd_name, 255 Red Rock Way #303H, San Francisco, CA, 94131
view__c, Garden/Greenbelt
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/530700688-1.jpg
