meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='329900' 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] => 2018-10-29 01:19:04
[post_modified_gmt] => 2018-10-29 01:19:04
[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, 175 Red Rock Way #207K, San Francisco, CA, 94131
ffd_mls_id, 423734168
ffd_salesforce_id, a0E8W00000bbK1oUAE
num_of_fireplaces__c, 1
num_of_rooms__c, 2
of_units__c, 396
address2__c, 175 Red Rock Way #207K, San Francisco, CA, 94131
pba__address_pb__c, 175 Red Rock Way #207K, San Francisco, CA, 94131
agent_only_remarks__c, Please email/text listing agent for showings - owner occupied so 24-hours notice needed. Offers on SFAR contract and include pre-approval/proof of funds. Happy to show your buyers with or without agent. Disclosures at: https://app.disclosures.io/link/175-Red-Rock-Way-207K-viuidonh 175RedRockWay207K.com
appliances__c, Dishwasher;Hood Over Range;Free Standing Refrigerator;Built-In Electric Range;Free Standing Electric Range
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
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-04-17T10:48:58.000+0000
days_on_market__c, 45
dom__c, 44
ffd_description_pb, Big bright alcove studio in Diamond Heights! Great space and layout allow for 2 distinct areas, one for entertaining and one private just for you. Open plan living/dining room enjoys bay window outlooks to a large manicured garden with mature trees, koi pond and meandering paths. Relax in front of a stately fireplace and hear the babbling brook outside. Remodeled kitchen includes plenty of storage and pass through breakfast bar and large pantry closet. On the other side is an enormous sleeping alcove, updated bathroom and walk-in closet. Easily divide the space for privacy or open it up for a larger gathering. Take the elevator from street level for maximum convenience. Walk to nearby shopping and restaurants. Go for a run or take the dog on one of the endless trails of Glen Park, Twin Peaks or the Upper Douglass Dog Park. Centrally located complex with easy access to the entire city, freeways and transit and your own assigned secure garage spot. Grab a foothold above our city of dreams!
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk,Shared Driveway
entry_level__c, 0
exterior_features__c, Uncovered Courtyard;Entry Gate
external_listing__c, 1
fireplace_features__c, Living Room;Gas Log
pba__floortype_pb__c, Carpet;Laminate;Tile
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, 594
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Diamond Heights Village Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace;Gas;Fireplace(s)
ffd_lastmodifieddate, 2023-05-31T15:48:42.000+0000
pba__latitude_pb__c, 37.745822
pba__latitude_property__c, 37.745822
laundry_features__c, In Garage
listed_date__c, 2022-12-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Daniel Kirk
pba__listing_agent_lastname__c, Slaughter
listing_agent_mls_id__c, 810046
ffd_listingagentname, Dan Slaughter
listing_agent_number__c, 1044471
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 505000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.175RedRockWay207K.com/mls
pba__longitude_pb__c, -122.441873
mls_id__c, 423734168
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0O1I000001ViHDUA0
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-04-17
open_house_end__c, 2023-06-04T16:00:00.000+0000
open_house_start__c, 2023-06-04T14:00:00.000+0000
original_price__c, 505000
overall_days_on_market__c, -81555
parking_access__c, Side by Side
parking_features__c, Assigned,Attached,Garage Door Opener,Side-by-Side
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, 853.04
pba__propertytype__c, Condominium
ListingId, a0E8W00000bbK1oUAE
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate
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, 0
pba__street_pb__c, Red Rock
subdist__c, Diamond Heights
ffd_name, 175 Red Rock Way #207K, San Francisco, CA, 94131
view__c, Garden/Greenbelt
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Window Coverings;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/530603827-1.jpg
