meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='222757' 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] => 2023-10-30 17:01:45
[post_modified_gmt] => 2023-10-31 00:01:45
[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, 610 Teresita Boulevard, San Francisco, CA, 94127
ffd_mls_id, 478521
ffd_salesforce_id, a0E1I000004ul4zUAA
address2__c, 610 Teresita Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 610 Teresita Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, Incredible home on a level lot For Disclosures request through Diclosures io
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
ffd_createddate, 2018-11-05T20:45:59.000+0000
days_on_market__c, 1717
dom__c, 25
ffd_description_pb, Tucked away on Teresita Blvd., a lovely midcentury Miraloma Park home is your retreat. Upon entering the home the living room features corner windows overlooking the San Francisco Bay and Easy Bay Hills. This perfectly laid out home is ideal for entertaining and comfortable everyday living The main living level features an open living/dining room combination with parquet floors and fireplace. The inside center patio gives abundant natural light into the home. The kitchen features updated cabinetry and new stainless steel appliances The two bedrooms on the upper level overlook the mature and lush garden. The flexible lower level could be either a master suite or family room.
district__c, SF District 4
external_listing__c, 1
hoa_dues__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-03-01T19:23:19.000+0000
pba__latitude_pb__c, 37.737320
pba__latitude_property__c, 37.737320
listed_date__c, 2018-10-29
pba__listing_agent_firstname__c, David
pba__listing_agent_lastname__c, Barrett
listing_agent_mls_id__c, 803422
listing_agent_number__c, 803422
listing_co_agent_mls_id__c, 807677
listing_co_agent_number__c, 1023767
listing_co_office_mls_id__c, WRWK
listing_co_office_name__c, Warwick Properties Group
listing_co_office_number__c, 3024
listing_office_mls_id__c, WRWK
listing_office_name__c, Warwick Properties Group
listing_office_number__c, 3024
pba__listingprice_pb__c, 1575000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.610teresita.com
pba__longitude_pb__c, -122.446609
pba__lotsize_pb__c, 0.07
mls_id__c, 478521
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2018-11-05
original_price__c, 1685000
overall_days_on_market__c, 1717
parking__c, Garage,Interior Access
parking_type__c, On Site
price_per_square_foot__c, 926.35
pba__propertytype__c, Single-Family Home
id, a0E1I000004ul4zUAA
sale_date__c, 2018-12-11
sale_price__c, 1610000
selling_agent_mls_id__c, 244893
selling_agent_name__c, Cynthia D. Cummins
selling_agent_number__c, 244893
selling_co_agent_mls_id__c, 810237
selling_co_agent_name__c, Laraine Hsu
selling_co_agent_number__c, 1045100
selling_co_office_mls_id__c, MCGU
selling_co_office_name__c, McGuire Real Estate
selling_co_office_number__c, 1497
selling_office_name__c, McGuire Real Estate
pba__status__c, Sold
pba__totalarea_pb__c, 1738
size__c, 1738
pba__state_pb__c, CA
pba__street_pb__c, Teresita
subdist__c, Miraloma Park
ffd_name, 610 Teresita Boulevard, San Francisco, CA, 94127
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/344566-1.jpg
ListingId, a0E1I000004ul4zUAA