meta_query='key:subdist__c;value:Diamond Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375418' 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, 1712368705
ffd_listing_title, 282 Red Rock A Way, San Francisco, CA, 94131
ffd_mls_id, 424014940
ffd_salesforce_id, a0EUd000001WL8tMAG
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 75
address2__c, 282 Red Rock A Way, San Francisco, CA, 94131
pba__address_pb__c, 282 Red Rock A Way, San Francisco, CA, 94131
agent_only_remarks__c, Sellers request escrow remain with Chicago Title, Call Randy Garcia for showings 415-606-0979
appliances__c, Dishwasher;Hood Over Range;Electric Cook Top;Free Standing Refrigerator;Double Oven
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1964
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Randy Garcia
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-03-21T20:46:52.000+0000
days_on_market__c, 15
dom__c, 9
ffd_description_pb, Nestled in the coveted Diamond Heights neighborhood of San Francisco, this exquisite three-bedroom, two-and-a-half-bathroom condo offers the epitome of modern urban living. Upon entering, you're greeted by a spacious open floor plan that seamlessly integrates the living room, dining area, and kitchen, creating an ideal space for both relaxation and entertaining. Retreat to the luxurious master bedroom, complete with a full bathroom, balcony, and personal electric fireplace, offering a tranquil sanctuary to unwind after a long day. Additionally, this condo includes the added convenience of one parking space, and an additional storage cage, ensuring hassle-free city living. This Diamond Heights condo presents an unparalleled opportunity to experience the best of San Francisco living.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Electric
pba__floortype_pb__c, Linoleum;Tile
hoa_fee_includes__c, Common Areas,Earthquake Insurance,Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Trash,Water
pba__hoafees__c, 1172
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Red Rock Hill - Unit 2
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Electric
ffd_lastmodifieddate, 2024-04-06T01:47:35.000+0000
pba__latitude_pb__c, 37.74406815
pba__latitude_property__c, 37.74406815
laundry_features__c, Other;Ground Floor;No Hookups
listed_date__c, 2024-03-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Brandon
pba__listing_agent_lastname__c, Tran
listing_agent_mls_id__c, 813604
ffd_listingagentname, Brandon Tran
listing_agent_number__c, 1062459
listing_co_agent_mls_id__c, MLSL5089847
listing_co_agent_number__c, 981375245
listing_co_office_mls_id__c, FIHI-1
listing_co_office_name__c, Fifty Hills Real Estate
listing_co_office_number__c, 981087570
listing_office_mls_id__c, 50HILLS
listing_office_name__c, Fifty Hills Real Estate
listing_office_number__c, 28651
pba__listingprice_pb__c, 775000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=ngdGSJ1BtzK
pba__longitude_pb__c, -122.43861389
lower_level__c, Garage,Street Entrance
mls_id__c, 424014940
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Bidet
master_property__c, a0OUd0000057imDMAQ
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-03-21
original_price__c, 775000
overall_days_on_market__c, -81894
parking_access__c, Side by Side
parking_features__c, Assigned
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-03-30
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-05T11:45:44.000+0000
price_per_square_foot__c, 577.52
pba__propertytype__c, Condominium
ListingId, a0EUd000001WL8tMAG
room_type__c, Kitchen;Living Room;Possible Guest;Primary Bathroom;Primary Bedroom
sale_date__c, 2024-04-05
sale_price__c, 788888
security_features__c, Smoke Detector;Secured Access;Carbon Mon Detector
selling_agent_mls_id__c, MLSL5089847
selling_agent_number__c, 981375245
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Fifty Hills Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1366
size__c, 1366
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Red Rock
subdist__c, Diamond Heights
ffd_name, 282 Red Rock A Way, San Francisco, CA, 94131
view__c, San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1964
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530743229-1.jpg
