meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215055' 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, 714 Teresita Boulevard, San Francisco, CA, 94127
ffd_mls_id, 506912
ffd_salesforce_id, a0E1I00000THoQ7UAL
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 714 Teresita Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 714 Teresita Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, Pre-escrow is open with Sharon Chan of Old Republic Title Company. One parking is in the garage with interior access and the second parking is off-street outside of the garage. Buyer to verify square footage to their satisfaction. Easy to show, please use Calendly link for scheduling: https://calendly.com/ilyatsay/714-teresita-blvd-1?month=2020-09. For further questions, offer date information, please contact the Listing Agent.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range
bath_features__c, Shower Stall(s);Tub;Remodeled;Tile;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1931
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-09-25T18:46:01.000+0000
days_on_market__c, 1027
dom__c, 14
ffd_description_pb, Beautiful and serene, 714 Teresita is nestled in a beloved neighborhood and presents 2 spacious floors of living space, as well as a sizable backyard with a view. The main floor surrounds a courtyard atrium and includes the living room, formal dining room, kitchen, 2 bedrooms and a full bathroom. A third bedroom is situated on the lower floor, along with another bathroom, laundry room and a hermetically sealed office, perfect for privacy, musical instruments, or exercising. The backyard showcases expansive views and provides a private outdoors experience. Located in a beautiful neighborhood, 714 Teresita is just minutes away from West Portal, Glen Canyon Park and Mt. Davidson. It presents easy access to the freeway, Glen Park BART and other forms of transportation. Local grocery stores, like Canyon Market and Mollie Stones, are just blocks away, as well as Whole Foods and Safeway. From cafes and local eateries, to fine dining and so much more that this neighborhood has to offer.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:35:42.000+0000
pba__latitude_pb__c, 37.7352931
pba__latitude_property__c, 37.7352931
laundry_features__c, In Garage;Inside Room;Washer/Dryer Included
listed_date__c, 2020-09-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ilya
pba__listing_agent_lastname__c, Tsay
listing_agent_mls_id__c, 808677
ffd_listingagentname, ILYA Tsay
listing_agent_number__c, 1037584
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG06
listing_office_name__c, Vanguard Properties
listing_office_number__c, 25987
pba__listingprice_pb__c, 1595000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4465921
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 506912
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-09-25
original_price__c, 1595000
overall_days_on_market__c, 129
parking__c, Uncovered,Attached,Garage,Auto Door,Interior Access
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage,Uncovered
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2020-10-09
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 845.35
pba__propertytype__c, Single Family Residence
id, a0E1I00000THoQ7UAL
room_type__c, Storage;Office;Laundry;Atrium
sale_date__c, 2020-11-06
sale_price__c, 1700000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 810756
selling_agent_name__c, Katherine D. Tomassi
selling_agent_number__c, 1047830
selling_co_agent_mls_id__c, 815184
selling_co_agent_name__c, Madeline Mazzola
selling_co_agent_number__c, 1071370
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2011
size__c, 2011
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Teresita
subdist__c, Miraloma Park
ffd_name, 714 Teresita Boulevard, San Francisco, CA, 94127
view__c, City Lights
website_property_type__c, Single Family Home
window_features__c, Dual Pane
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/371033-1.jpg
ListingId, a0E1I00000THoQ7UAL
