meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219276' 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, 400 Teresita Boulevard, San Francisco, CA, 94127
ffd_mls_id, 421558475
ffd_salesforce_id, a0E1I00000UTwfIUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 400 Teresita Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 400 Teresita Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, On SUPRA - Offers due 6/14 by 6 pm.Call Bob (415) 308-5902 for any questions. Please submit your highest and best offer as Sellers may not counter offer and this home is now almost vacant with sellers living in their new home. Must be on the San Francisco Purchase Agreement with signed 1st page outline Disc Pkg Sheet.
appliances__c, Microwave;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Spanish;A-Frame
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1931
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-06-04T18:47:56.000+0000
days_on_market__c, 775
dom__c, 12
ffd_description_pb, Diamond in the rough - This Miraloma Park home With beautiful 1931 period detailing, 2 bedroom, 2 bath has great potentials! Formal living and dining rooms with high coved ceilings, polished parquet floors, mahogany colored wood trims. Swing door from dining room connects to the updated kitchen with breakfast nook. The cozy backyard can be a place for your gatherings and BBQ's. Conveniently located close to Muni(36,52), Bart, Mollie Stones, Glen Park and Noe valley shopping and restaurants, 101 and 280 Freeways. Check out neighbors homes to the right with their view penthouses!
district__c, SF District 4
driveway_sidewalks__c, Sidewalk/Curb/Gutter
electric__c, 220 Volts
entry_level__c, 0
exterior_features__c, Fireplace
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Marble;Wood;Parquet
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Fireplace(s)
interior_features__c, Formal Entry;Storage Area(s);Cathedral Ceiling
ffd_lastmodifieddate, 2022-01-25T15:54:14.000+0000
pba__latitude_pb__c, 37.7406334
pba__latitude_property__c, 37.7406334
laundry_features__c, In Garage;Hookups Only;Sink
listed_date__c, 2021-04-20
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Bob
pba__listing_agent_lastname__c, Evans (EVJENTH)
listing_agent_mls_id__c, 353080
ffd_listingagentname, Bob E Evans (EVJENTH)
listing_agent_number__c, 353080
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CAFH
listing_office_name__c, Century 21 Realty Alliance Fine Homes and Estates
listing_office_number__c, 166014509
pba__listingprice_pb__c, 1000000
pba__listingtype__c, Sale
pba__listing_website__c, https://400TeresitaBlvd41082mls.f8re.com/
pba__longitude_pb__c, -122.4493518
lower_level__c, Garage,Street Entrance
mls_id__c, 421558475
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Marble
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-06-04
original_price__c, 1000000
overall_days_on_market__c, 138
parking_access__c, Tandem
parking_features__c, Attached,Covered,Enclosed,Garage Door Opener,Garage Facing Front,Interior Access,Size Limited,Tandem Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Front Porch
pba__pendingdate__c, 2021-06-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1062.86
pba__propertytype__c, Single Family Residence
id, a0E1I00000UTwfIUAT
road_surface_type__c, Paved
roof__c, Tar/Gravel;Spanish Tile
room_type__c, Office;Kitchen;Living Room;Baths Other;Dining Room
sale_date__c, 2021-07-15
sale_price__c, 1488000
security_features__c, Smoke Detector
selling_agent_mls_id__c, EB147458
selling_agent_number__c, 981007531
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, 1400
size__c, 1400
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Teresita
subdist__c, Miraloma Park
ffd_name, 400 Teresita Boulevard, San Francisco, CA, 94127
view__c, City;San Francisco
website_property_type__c, Single Family Home
window_features__c, Window Coverings;Dual Pane Partial
pba__yearbuilt_pb__c, 1931
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530256247-1.jpg
ListingId, a0E1I00000UTwfIUAT