meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='419600' 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
(
)
)
_yoast_indexnow_last_ping, 1729220344
ffd_listing_title, 15 Teresita Boulevard #7, San Francisco, CA, 94127
ffd_mls_id, 424073934
ffd_salesforce_id, a0EUd000003O0TOMA0
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 14
address2__c, 15 Teresita Boulevard #7, San Francisco, CA, 94127
pba__address_pb__c, 15 Teresita Boulevard #7, San Francisco, CA, 94127
agent_only_remarks__c, Open Sunday 10/20, 1-4PM. More info, floor plans & Matterport for your clients at www.15Teresita7.com. Probate Sale, NO court required, NO death on property. NO need to call, please Email (not text) Listing Agent w/ ?s. Easy to show starting Friday 10/18 at 12noon. To schedule please use the ShowingTime App downloaded to your phone to book your time & receive complete showing instructions. Disclosures will be posted here Thursday 10/24 & likely not before. Offers reviewed Wednesday 10/30 by 1PM to allow for buyer & administrator due diligence. No preemptives please. Broker's Note: This is an As-Is Trust Sale. Graphic artist drawings & 3rd party property inspections provided are for informational purposes only, & buyers & agents should not rely on them for making offer or purchase decisions. Buyers are advised to get any & all inspections they deem necessary. Buyers should also verify all square footage & any & all room counts, room legality & permit history for themselves.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1990
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-10-18T00:55:54.000+0000
days_on_market__c, 0
dom__c, 0
ffd_description_pb, Rarely available 2BD/2BA two-story Contemporary Condo in the heart of coveted Miraloma Park, steps from Mollie Stone's, and just minutes from West Portal, Noe Valley, the Castro and more! 15 Teresita Blvd. #7, which is a rare corner unit with no downstairs or upstairs neighbors, greets visitors with a bright formal living room with big windows and fireplace and an adjoining dining room, both ready for entertaining or unwinding after a long day. Nearby is an updated granite and stainless steel kitchen with good counter and cabinet space. Upstairs are two ample bedrooms and two updated full baths, one with a shower over tub, and one with a new shower stall. Additional amenities including beautiful Cherry-wood floors, in-unit washer and dryer, private outdoor balcony in front of the unit, one car secured parking, and an attractive and secure interior courtyard, complete this offering. Excellent Central San Francisco location with plenty of on-street guest parking, steps to Mollie Stones, CVS, Starbucks, Creighton's Bakery, banks, dry cleaners, Muni and local schools, AND just minutes to West Portal, Noe Valley, the Castro, Glen Park, BART and local freeways to Downtown, Silicon Valley and beyond. For privacy, security, amenities and convenience, 15 Teresita #7 is not to be missed!
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
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 611
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Teresita Court HOAAssociation
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Baseboard;Radiant
ffd_lastmodifieddate, 2024-10-18T02:47:44.000+0000
pba__latitude_pb__c, 37.7450216
pba__latitude_property__c, 37.7450216
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2024-10-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andrew
pba__listing_agent_lastname__c, de Vries
listing_agent_mls_id__c, 803319
ffd_listingagentname, Andrew de Vries
listing_agent_number__c, 803319
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BHFP
listing_office_name__c, Berkshire Hathaway-Franciscan
listing_office_number__c, 1665
pba__listingprice_pb__c, 798000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=rKQBtNbwc5n&brand=0
pba__longitude_pb__c, -122.4517301
mls_id__c, 424073934
main_level__c, Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0OUd00000DPr4sMAD
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-10-17
open_house_end__c, 2024-10-20T16:00:00.000+0000
open_house_start__c, 2024-10-20T13:00:00.000+0000
original_price__c, 798000
overall_days_on_market__c, -82104
parking_access__c, Independent
parking_features__c, Assigned,Attached,Interior Access
parking_type__c, On Site - Assigned (Condo Only);On Site - Mapped (Condo Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 828.66
pba__propertytype__c, Condominium
ListingId, a0EUd000003O0TOMA0
room_type__c, Kitchen;Living Room;Dining Room
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 963
size__c, 963
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Teresita
subdist__c, Miraloma Park
ffd_name, 15 Teresita Boulevard #7, San Francisco, CA, 94127
view__c, Twin Peaks
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1990
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530873790-1.jpg
