Array
(
[ID] => 70665
[post_author] => 4
[post_date] => 2018-11-30 20:30:39
[post_date_gmt] => 2018-11-30 20:30:39
[post_content] => Storybook stucco charmers and mid-century modern masterpieces meander through this semi-circular neighborhood that fans out to the northeast, east, and southeast from the base of Mt. Davidson before coming to an abrupt stop at the top of Glen Canyon Park.
[post_title] => Miraloma Park
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => miraloma-park
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-14 22:22:22
[post_modified_gmt] => 2024-11-15 06:22:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70665
[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, 474 Melrose Avenue, San Francisco, CA, 94127
ffd_mls_id, 502993
ffd_salesforce_id, a0E1I00000S11fUUAR
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 474 Melrose Avenue, San Francisco, CA, 94127
pba__address_pb__c, 474 Melrose Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Pre-escrow opened with Helen Dumont at ORTC. Private showings available. Schedule appointment at following link: https://calendly.com/474melroseave/30min. Appointments will be confirmed after PEAD has been received. A face mask is required to enter the home and please hand sanitize upon entry. In-person showings are limited to 2 prospective buyers and 1 agent. Seller reserves the right to accept, counter, or refuse any offers. Disclosures are available in the MLS Disclosure IO link. Link to 3D Walkthrough: https://www.asteroommls.com/pviewer?token=ADjYCMndD0qKDUAadK-6Iw
ffd_description_pb, Up a tiled stairway, this sweet, single family home is a city oasis in Miraloma Park. 474 Melrose Avenue offers 3 bedrooms, 2 baths, and an ideal floor plan for entertaining. The updated kitchen features elegant wood built-ins and a cozy eating nook. In the living room, a fireplace invites nights with friends and family. The 2 bedrooms on the main level are bathed in natural light from large windows, and the spacious master suite is a private retreat which occupies its own setback section of the home. Elegant finishes throughout the home include ornate door knobs and painted tiles on the short staircase down to the backyard. With access through both the main house and the master suite, the sun drenched and multi-leveled terraced backyard is just right for gardening, barbecuing, and sunbathing. An environmentally friendly smart home, 474 Melrose features solar panels and is car charger ready. Located close to freeways, transit, parks, & the Glen Park and West Portal shopping corridors.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
electric__c, 220 Volts in Kitchen,220 Volts in Laundry
474 Melrose Avenue, San Francisco, CA, 94127 - Property Description
Up a tiled stairway, this sweet, single family home is a city oasis in Miraloma Park. 474 Melrose Avenue offers 3 bedrooms, 2 baths, and an ideal floor plan for entertaining. The updated kitchen features elegant wood built-ins and a cozy eating nook. In the living room, a fireplace invites nights with friends and family. The 2 bedrooms on the main level are bathed in natural light from large windows, and the spacious master suite is a private retreat which occupies its own setback section of the home. Elegant finishes throughout the home include ornate door knobs and painted tiles on the short staircase down to the backyard. With access through both the main house and the master suite, the sun drenched and multi-leveled terraced backyard is just right for gardening, barbecuing, and sunbathing. An environmentally friendly smart home, 474 Melrose features solar panels and is car charger ready. Located close to freeways, transit, parks, & the Glen Park and West Portal shopping corridors.
