Array
(
[ID] => 70668
[post_author] => 4
[post_date] => 2018-11-30 20:30:43
[post_date_gmt] => 2018-11-30 20:30:43
[post_content] => Stately single-family homes with views to the southwest at the base of Mt. Davidson define this West of Twin Peaks classic. Like its adjacent neighbors, it assumes you've got a car to get you to and from some jaw-dropping views.
[post_title] => Westwood Highlands
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => westwood-highlands
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-21 11:34:43
[post_modified_gmt] => 2024-11-21 19:34:43
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70668
[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, 504 Melrose Avenue, San Francisco, CA, 94127
ffd_mls_id, 421574499
ffd_salesforce_id, a0E1I00000UV5BGUA1
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 504 Melrose Avenue, San Francisco, CA, 94127
pba__address_pb__c, 504 Melrose Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Offer update: Offers due Wednesday, July 21 by 3pm. Disclosures available via disclosures.io at https://app.disclosures.io/link/504-Melrose-Avenue-lqxln40g Email offers to [email protected], including proof of funds, preapproval letter, & signed disclosure coversheet. Use calendly link to schedule private tour (you will received auto-email from Calendly with CBS code): https://calendly.com/morgan-cook-realtor/504-melrose-ave (Supra box is located on the front door of home, security gate is unlocked). All visitors must wear a mask while in the home and please limit touching surfaces. LEAVE LIGHTS ON and remove shoes or wear disposable booties which are located inside front door (please discard in trash can after use). Agents: be sure to share link to aerial video with your buyers (they will be in awe): https://vimeo.com/575326796
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range
architectural_style__c, Contemporary
bath_features__c, Skylight/Solar Tube;Quartz
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-07-16T01:50:56.000+0000
days_on_market__c, 1265
dom__c, 6
ffd_description_pb, Westwood Highlands stunner! Completely renovated from top to bottom, this gorgeous detached home features an open floor plan with natural light that cascades into the living room which flows into the beautiful kitchen showcasing quartz countertops, soft-close cabinets, tile backsplash, and SS appliances. Top floor en-suite features a natural light immersed bedroom and bathroom featuring a skylight. Venture downstairs past the glass stair railing into the 2nd en-suite which features dual closets w/organizers, entry to the yard, and a spa inspired bathroom w/dual vanities, marble countertops, curb-less shower w/frameless glass door, and floor-to-ceiling tiled wall. The 3rd bedroom (staged as an office) also features access to the yard. Tastefully done yard features breathtaking views of the city! Other thoughtfully appointed features include perfect smooth walls, dimmer switches in bedrooms, Nest thermostat, Ring doorbell, and more.
504 Melrose Avenue, San Francisco, CA, 94127 - Property Description
Westwood Highlands stunner! Completely renovated from top to bottom, this gorgeous detached home features an open floor plan with natural light that cascades into the living room which flows into the beautiful kitchen showcasing quartz countertops, soft-close cabinets, tile backsplash, and SS appliances. Top floor en-suite features a natural light immersed bedroom and bathroom featuring a skylight. Venture downstairs past the glass stair railing into the 2nd en-suite which features dual closets w/organizers, entry to the yard, and a spa inspired bathroom w/dual vanities, marble countertops, curb-less shower w/frameless glass door, and floor-to-ceiling tiled wall. The 3rd bedroom (staged as an office) also features access to the yard. Tastefully done yard features breathtaking views of the city! Other thoughtfully appointed features include perfect smooth walls, dimmer switches in bedrooms, Nest thermostat, Ring doorbell, and more.
