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, 290 Red Rock Way #B, San Francisco, CA, 94131
ffd_mls_id, 422712529
ffd_salesforce_id, a0E8W00000a8O4DUAU
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 76
address2__c, 290 Red Rock Way #B, San Francisco, CA, 94131
pba__address_pb__c, 290 Red Rock Way #B, San Francisco, CA, 94131
agent_only_remarks__c, Buyers shall verify sqft and make any independent inquiries to satisfy themselves for any Q's in the MLS private remarks, the disclosures or otherwise. For showings and questions, contact Susie Lee at 415-933-7893 via text/email [email protected]. Disclosure package will be ready soon.
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Bill Mar
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-03T11:48:28.000+0000
days_on_market__c, 166
dom__c, 0
ffd_description_pb, Major bargain deal for a TOP FLOOR 4 BEDROOM 3 FULL BATHS condo with 3 CAR PARKING, MOUNTAIN VISTA VIEWS, and 4 PRIVATE BALCONIES!! It can't get any better than this in the highly desirable and safe DIAMOND HEIGHTS!! OVERSIZED WINDOWS with sliding doors flood the entire unit with AMPLE SUNLIGHT and fresh clean air. The quiet unit is privately nestled amongst serene trees with dense green canopies. PERFECT LOCATION to comfortably walk your dog or conveniently access GLEN CANYON HIKING TRAILS near this relaxing neighborhood. HOA is well organized and even includes EARTHQUAKE INSURANCE, water, trash, building insurance, and maintenance. Just minutes away from MUNI, Diamond Heights Shopping Center (Safeway, Starbucks, Walgreens), Glen Park Bart Station, and Highways 280/101. Enjoy infinitely stunning views of MOUNT DAVIDSON, Glen Canyon Park, Sutro Tower, and sparkling city Twilight views from all sides of your home! New interior paint and quality flooring, and recently restored exterior building stucco with fresh paint! Interior access to garage, ABUNDANT STORAGE, and plentiful closet and EXTRA CABINET SPACE in the hallways and bedrooms. THIS ONE DEFINITELY WON'T LAST LONG - Come and get it NOW OFF-MARKET before it goes active on the market soon! 290RedRockB.com
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
hoa_fee_includes__c, Common Areas,Earthquake Insurance,Homeowners Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Trash,Water
pba__hoafees__c, 1349
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Red Rock Hill - Unit 2 Condominium HOA
290 Red Rock Way #B, San Francisco, CA, 94131 - Property Description
Major bargain deal for a TOP FLOOR 4 BEDROOM 3 FULL BATHS condo with 3 CAR PARKING, MOUNTAIN VISTA VIEWS, and 4 PRIVATE BALCONIES!! It can't get any better than this in the highly desirable and safe DIAMOND HEIGHTS!! OVERSIZED WINDOWS with sliding doors flood the entire unit with AMPLE SUNLIGHT and fresh clean air. The quiet unit is privately nestled amongst serene trees with dense green canopies. PERFECT LOCATION to comfortably walk your dog or conveniently access GLEN CANYON HIKING TRAILS near this relaxing neighborhood. HOA is well organized and even includes EARTHQUAKE INSURANCE, water, trash, building insurance, and maintenance. Just minutes away from MUNI, Diamond Heights Shopping Center (Safeway, Starbucks, Walgreens), Glen Park Bart Station, and Highways 280/101. Enjoy infinitely stunning views of MOUNT DAVIDSON, Glen Canyon Park, Sutro Tower, and sparkling city Twilight views from all sides of your home! New interior paint and quality flooring, and recently restored exterior building stucco with fresh paint! Interior access to garage, ABUNDANT STORAGE, and plentiful closet and EXTRA CABINET SPACE in the hallways and bedrooms. THIS ONE DEFINITELY WON'T LAST LONG - Come and get it NOW OFF-MARKET before it goes active on the market soon! 290RedRockB.com
* Disclaimer: MLS listing information is deemed reliable but is not guaranteed by the service.
* Listing Agent: Susie Lee, Co-listing Agent: Bill Mar
Virtual Tour
Listing Details for 290 Red Rock Way #B
HOA Information
HOA Information
Association: Yes
Association Fee: $1349
Association Fee Frequency: Monthly
Association Fee Includes: Common Areas,Earthquake Insurance,Homeowners Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Trash,Water
# of Units (Total): 76
Parking & Garage Information
Parking & Garage Information
Parking Total: 3
Parking Type: On Site - Assigned (Condo Only)
Parking Access: Independent
Parking Features: Covered,Enclosed,Garage Door Opener,Interior Access
