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-04-11 08:26:13
[post_modified_gmt] => 2024-04-11 15:26:13
[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, 527 Teresita Boulevard, San Francisco, CA, 94127
ffd_mls_id, 422713371
ffd_salesforce_id, a0E8W00000baXTSUA2
num_of_fireplaces__c, 2
num_of_rooms__c, 0
of_units__c, 0
address2__c, 527 Teresita Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 527 Teresita Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, Call Joseph Chav at 415-980-9262 with questions regarding offers. Offers should be on the CAR contract and include a pre-approval, proof of funds and fully signed disclosures. Please wear booties while showing, turn off all lights and lock all doors after showing. Prefer escrow with Christine Lim at Old Republic Title on 24th St. Buyer to verify exact square footage and bedroom count. *** 3D Tour: https://my.matterport.com/show/?m=oVLnSzwBqnZ&brand=0 *** Aerial Video: https://youtu.be/-agnTS9owo4
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1939
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Roque E Fernandes
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-04-01T10:49:04.000+0000
days_on_market__c, 110
dom__c, 7
ffd_description_pb, Breathtaking views abound from this captivating semi-detached home in the idyllic Miraloma Park neighborhood. Filled with natural light, this 4 bedroom and 2 bathroom gem will leave you feeling inspired. The upstairs features a beautifully updated kitchen with a sunny breakfast area, a formal dining room, and an elegant living room with a fireplace and sliding glass door that opens to an expansive deck where you can relax and enjoy stunning views of the bay. Also on this level are 2 spacious bedrooms and a full bathroom. The lower level includes 2 bedrooms, an exquisitely redesigned bathroom, and a few steps down into a spectacular family room with high ceilings and large windows framing the vast, tranquil backyard and the views beyond. A 2 car garage with a laundry area and workshop space also contains a bonus room, perfect for a home office. This highly desired location is conveniently close to Mount Davidson hiking trails, Glen Canyon Park, Mollie Stone's/Tower Market, and the unique variety of shops and restaurants in Glen Park Village and West Portal. Easy access to MUNI, BART and major freeways.
527 Teresita Boulevard, San Francisco, CA, 94127 - Property Description
Breathtaking views abound from this captivating semi-detached home in the idyllic Miraloma Park neighborhood. Filled with natural light, this 4 bedroom and 2 bathroom gem will leave you feeling inspired. The upstairs features a beautifully updated kitchen with a sunny breakfast area, a formal dining room, and an elegant living room with a fireplace and sliding glass door that opens to an expansive deck where you can relax and enjoy stunning views of the bay. Also on this level are 2 spacious bedrooms and a full bathroom. The lower level includes 2 bedrooms, an exquisitely redesigned bathroom, and a few steps down into a spectacular family room with high ceilings and large windows framing the vast, tranquil backyard and the views beyond. A 2 car garage with a laundry area and workshop space also contains a bonus room, perfect for a home office. This highly desired location is conveniently close to Mount Davidson hiking trails, Glen Canyon Park, Mollie Stone's/Tower Market, and the unique variety of shops and restaurants in Glen Park Village and West Portal. Easy access to MUNI, BART and major freeways.
