meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212127' posts_per_page=4 post_type=property
bool(false)
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, 24 Arroyo Way, San Francisco, CA, 94127
ffd_mls_id, 496007
ffd_salesforce_id, a0E1I00000SlhkTUAR
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 24 Arroyo Way, San Francisco, CA, 94127
pba__address_pb__c, 24 Arroyo Way, San Francisco, CA, 94127
agent_only_remarks__c, Showings subject to COVID-19 SIP guidelines. Please review photos and video, review disclosures, and provide pre-approval and/or proof of funds for showing Pre-escrow opened with Kristin Therre at Old Republic. Please submit offers on 7 page SFAR contact, with POF/lender approval letter and signed disclosures. Please contact Michelle Balog at 415-810-7890/[email protected] or Evan Bliss at 415.816.9225/[email protected] with any questions or showing requests.
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1947
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Evan Bliss
pba__contingentdate__c, 2020-05-23
ffd_createddate, 2020-05-16T10:45:47.000+0000
days_on_market__c, 1160
dom__c, 19
ffd_description_pb, Adorable two-story Miraloma Park single family home is detached on three sides for a light-filled upstairs featuring two bedrooms overlooking the expansive backyard & patio and four-piece bath with spa tub and separate shower. Downstairs includes a third bedroom* and second full bathroom* with steam shower, plus bonus family room/office/gym* (*unwarranted). The open living room is accented with a wood-burning fireplace. The kitchen offers plenty of counter space, storage, and stainless steel appliances: gas range, wine fridge, and dishwasher. Hardwood floors throughout on the upper level. New carpet downstairs, new light fixtures, and paint to most of the interior. Gorgeous landscaped yard, 1-car garage parking, and laundry complete this home. Great location: Close proximity to Molly Stone's, Starbucks, and the wonderful Miraloma Elementary. Short ride to Glen Park, Inner Sunset, Noe, Castro, Bernal, or the Missionplus, easy commute with fast access to BART, 101 and 280.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Carpet;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:21:45.000+0000
pba__latitude_pb__c, 37.739163
pba__latitude_property__c, 37.739163
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-02-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michelle
pba__listing_agent_lastname__c, Balog
listing_agent_mls_id__c, 803379
ffd_listingagentname, Michelle L Balog
listing_agent_number__c, 803379
listing_co_agent_mls_id__c, 808381
listing_co_agent_number__c, 1034267
listing_co_office_mls_id__c, BAYRE
listing_co_office_name__c, Bay Real Estate Group
listing_co_office_number__c, 28186
listing_office_mls_id__c, BAYRE
listing_office_name__c, Bay Real Estate Group
listing_office_number__c, 28186
pba__listingprice_pb__c, 1549000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/419224571
pba__longitude_pb__c, -122.447239
pba__lotsize_pb__c, 0.07
mls_id__c, 496007
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-05-15
original_price__c, 1549000
overall_days_on_market__c, 76
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-06-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 984.03
pba__propertytype__c, Single Family Residence
id, a0E1I00000SlhkTUAR
sale_date__c, 2020-07-02
sale_price__c, 1540000
selling_agent_mls_id__c, 811200
selling_agent_name__c, Mary Liu
selling_agent_number__c, 1050357
selling_co_agent_mls_id__c, 113543
selling_co_agent_name__c, James S. Wong
selling_co_agent_number__c, 113543
selling_co_office_mls_id__c, VANG06
selling_co_office_name__c, Vanguard Properties
selling_co_office_number__c, 25987
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1565
size__c, 1565
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Arroyo
subdist__c, Miraloma Park
ffd_name, 24 Arroyo Way, San Francisco, CA, 94127
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1947
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/362672-1.jpg
ListingId, a0E1I00000SlhkTUAR