meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='381543' 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, 1729025745
ffd_listing_title, 135 Red Rock Way #203L, San Francisco, CA, 94131
ffd_mls_id, 424046099
ffd_salesforce_id, a0EUd000002Tm89MAC
num_of_fireplaces__c, 1
num_of_rooms__c, 2
of_units__c, 396
address2__c, 135 Red Rock Way #203L, San Francisco, CA, 94131
pba__address_pb__c, 135 Red Rock Way #203L, San Francisco, CA, 94131
agent_only_remarks__c, Please call Charlie at 269-3705 with questions, for disclosures and to show. FHA Approved Complex.Agent lives in building and can show on short notice. There is keypad entry installed on the unit door and I can also buzz you into the bldg. For your convenience a pre-sale escrow has been opened at WFG Title. Offers reviewed upon presentation. All Offers MUST be on an SFAR or CAR contract.
appliances__c, Dishwasher;Hood Over Range;Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Split Bath
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1972
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-07-03T01:47:01.000+0000
days_on_market__c, 105
dom__c, 105
ffd_description_pb, Welcome Home! This sunny, remodeled condominium is nestled above a soothing bucolic courtyard and faces south. DHV #L203 has been freshly repainted and had it's popcorn ceiling professionally removed. All new carpeting has been added in the living and sleeping areas with new engineered wood flooring in the entry, kitchen, vanity and bath areas. Other features include a galley kitchen, separate vanity and wet area, pass-thru closets and dressing area, breakfast bar with a spacious main living area highlighted by a gas fireplace. This gracious home has views to the south, over the central courtyard which has a series of cascading koi ponds, surrounded by a curated mix of native and drought-tolerant landscaping. Living here is like being in your own private park. This condo makes for a great pied a terre or starter home and is ready for move right in! As a member of Diamond Hts Village you will enjoy an outdoor resort-style heated pool, fitness center with machines, free-weights, universal press, sauna, and whirlpool spa, clubhouse with several seating areas, billiards, and free Wi-Fi throughout and also poolside, on-site mgmnt. Condo comes complete with its own deeded, garage parking space at no extra monthly charge. EV charging too.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Log
pba__floortype_pb__c, Carpet;Simulated Wood
hoa_fee_includes__c, Common Areas,Earthquake Insurance,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Roof,Sewer,Trash,Water
pba__hoafees__c, 645
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Diamond Heights Village Assn
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace;Fireplace(s)
ffd_lastmodifieddate, 2024-10-15T20:47:25.000+0000
pba__latitude_pb__c, 37.7462077
pba__latitude_property__c, 37.7462077
laundry_features__c, Inside Room
listed_date__c, 2024-07-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Charles
pba__listing_agent_lastname__c, Mader
listing_agent_mls_id__c, 803056
ffd_listingagentname, Charles W Mader
listing_agent_number__c, 803056
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, PKNO
listing_office_name__c, Park North Real Estate
listing_office_number__c, 24343
pba__listingprice_pb__c, 525000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.youtube.com/watch?v=tsNVVtK-7M8
pba__longitude_pb__c, -122.4420063
mls_id__c, 424046099
master_property__c, a0O1I000001ViQXUA0
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-07-02
open_house_end__c, 2024-10-15T15:00:00.000+0000
open_house_start__c, 2024-10-15T13:00:00.000+0000
original_price__c, 500000
overall_days_on_market__c, -81997
parking_access__c, Side by Side
parking_features__c, Interior Access
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, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 886.82
pba__propertytype__c, Condominium
ListingId, a0EUd000002Tm89MAC
roof__c, Tar/Gravel
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Fire Alarm;Fire Extinguisher;Carbon Mon Detector
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, 592
size__c, 592
spa__c, 1
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Red Rock
subdist__c, Diamond Heights
ffd_name, 135 Red Rock Way #203L, San Francisco, CA, 94131
view__c, Garden/Greenbelt
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Bay Window(s)
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/530804215-1.jpg
