meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214453' 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, 978 Teresita Boulevard, San Francisco, CA, 94127
ffd_mls_id, 504668
ffd_salesforce_id, a0E1I00000THjxbUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 978 Teresita Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 978 Teresita Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, Easy to show with appointment! Contact Eric Sandate at 415-319-3065/[email protected] for more information. Offers, if any, are to be submitted by 2PM on 9/25/20. Disclosures available in Disclosures.io. 1000 sq ft per public records; ~1200 sq ft per owner; bonus space and half bath are estimated at ~195 sq ft, not included in public records. Buyer to verify sq ft to their own satisfaction. Private showings available with COVID rules in place. Tour here - https://youtu.be/bKCpzu0_T1Q .
appliances__c, Gas Water Heater;Gas Range;Refrigerator;Freestanding Range
architectural_style__c, Spanish/Med
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1937
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Eric Sandate
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-17T01:46:17.000+0000
days_on_market__c, 1036
dom__c, 12
ffd_description_pb, Gorgeous Spanish Mediterranean Home in Marvelous Miraloma Park! Beautiful refinished hardwood floors, and newly painted throughout. Boasts two large bedrooms with ample closets on the main level. Bright and light throughout with a period kitchen featuring distinct SF architectural details and is lovely as-is or will be perfect with a new owner's custom finishes. Huge bonus room and half bath downstairs for the perfect home-office or just the right space for visiting friends and family. Backyard has a BBQ area with a special terraced garden and canyon views. Shop at nearby Mollie Stone's, CVS, and more. A stone's throw from Miraloma Playground, Park and Tennis Center, Glen Park and Glen Park BART, Mt. Davidson, and easy access to HWY 101 and 280.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Tile;Vinyl;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
ffd_lastmodifieddate, 2022-01-25T15:33:00.000+0000
pba__latitude_pb__c, 37.7344527
pba__latitude_property__c, 37.7344527
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-08-31
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Carol
pba__listing_agent_lastname__c, Reen
listing_agent_mls_id__c, 808330
ffd_listingagentname, Carol Reen
listing_agent_number__c, 1033515
listing_co_agent_mls_id__c, 810072
listing_co_agent_number__c, 1044590
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1198000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/bKCpzu0_T1Q
pba__longitude_pb__c, -122.4478533
pba__lotsize_pb__c, 0.06
lower_level__c, Partial Bath(s)
mls_id__c, 504668
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-09-16
original_price__c, 1198000
overall_days_on_market__c, 112
parking__c, Attached,Garage
parking_features__c, Attached,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-09-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1025
pba__propertytype__c, Single Family Residence
id, a0E1I00000THjxbUAD
room_type__c, Bonus Room
sale_date__c, 2020-10-30
sale_price__c, 1230000
selling_agent_mls_id__c, 809119
selling_agent_name__c, Judson B. Gregory
selling_agent_number__c, 1040495
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1200
size__c, 1200
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Teresita
subdist__c, Miraloma Park
ffd_name, 978 Teresita Boulevard, San Francisco, CA, 94127
transportation__c, 3 Blocks
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1937
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/369440-1.jpg
ListingId, a0E1I00000THjxbUAD