meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212118' 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, 620 Teresita Boulevard, San Francisco, CA, 94127
ffd_mls_id, 497676
ffd_salesforce_id, a0E1I00000SlVVCUA3
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 620 Teresita Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 620 Teresita Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, easy too show COVID compliant. Vacant. offer date to be established but seller reserves the right to accept a pre emptive offer. cal Dan at 415.203.9505 to show.
appliances__c, Dishwasher;Gas Range;Refrigerator;Freezer
architectural_style__c, Traditional
bath_features__c, Shower Stall(s);Tub;Low-Flow Toilet(s);Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-05-12
ffd_createddate, 2020-05-04T19:47:17.000+0000
days_on_market__c, 1171
dom__c, 38
ffd_description_pb, Fantastic model home in prime Miraloma park. Three bedrooms all on the main floor. Vaulted ceilings and wood burning fireplace in living room, formal dining room, large eat in kitchen. bright and freshly painted, new fixtures, updated lighting, electrical, double paned windows, and an enchanting garden in the rear yard. Excellent potential for expansion, high ceilings in lower level and the area below rear bedroom can be enclosed too. 2/ 3 car garage. Dont miss out this is a gem!
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:21:45.000+0000
pba__latitude_pb__c, 37.73711
pba__latitude_property__c, 37.73711
laundry_features__c, In Garage
listed_date__c, 2020-05-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Daniel
pba__listing_agent_lastname__c, Hendel
listing_agent_mls_id__c, 520862
ffd_listingagentname, Daniel Hendel
listing_agent_number__c, 520862
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COLD03
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 875
pba__listingprice_pb__c, 1299000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.44642
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Family Room
mls_id__c, 497676
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2020-05-04
original_price__c, 1299000
overall_days_on_market__c, 120
parking__c, Garage,Interior Access
parking_features__c, Interior Access,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-06-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 989.66
pba__propertytype__c, Single Family Residence
id, a0E1I00000SlVVCUA3
sale_date__c, 2020-06-15
sale_price__c, 1435000
selling_agent_mls_id__c, 804837
selling_agent_name__c, John L. LePage
selling_agent_number__c, 166014530
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 1450
size__c, 1450
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Teresita
subdist__c, Miraloma Park
ffd_name, 620 Teresita Boulevard, San Francisco, CA, 94127
transportation__c, 1 Block
view__c, Partial
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/362702-1.jpg
ListingId, a0E1I00000SlVVCUA3