meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='346951' 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-11-14 22:22:22
[post_modified_gmt] => 2024-11-15 06:22:22
[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, 1735680563
ffd_listing_title, 566 Teresita Boulevard, San Francisco, CA, 94127
ffd_mls_id, 423922223
ffd_salesforce_id, a0EUd0000004eoWMAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 566 Teresita Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 566 Teresita Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, Call Joseph Chav at 415-980-9262 with questions regarding offers. Offers should include a pre-approval, proof of funds and fully signed disclosures. One of the Sellers is an active licensed real estate agent. Please turn off all lights and lock all doors after showing. Prefer escrow with Christine Lim at Old Republic Title on 2566 Ocean Ave. Upstairs Square footage is 1222 Sqft per artist. Tax Records reflects 1216 Sqft Upstairs. Lower Level 580 Sqft of living space is unwarranted. Buyer to verify exact square footage and room count. Disclosure:* https://app.disclosures.io/link/566-Teresita-Boulevard-9g5wj0df* *3D Tour: https://my.matterport.com/show/?m=e7diDLaMqZz * Drone Video https://youtu.be/jXSXtxkY4kg *
appliances__c, Dishwasher;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Roque E Fernandes
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-11-10T21:46:57.000+0000
days_on_market__c, 417
dom__c, 17
ffd_description_pb, Welcome to this exquisite remodeled home nestled in the coveted Miraloma Park neighborhood. This spacious Center-Patio home boasts three bedrooms and two baths, offering a perfect blend of luxury and functionality. The upstairs features a modern kitchen with a breakfast nook, formal dining, and an elegant living room with a cozy fireplace. Two generously sized bedrooms and a large bathroom complete this level. The lower level presents a spacious ensuite bedroom, a beautifully redesigned bathroom, and a family room, complete with a modern wet bar. The many upgrades include beautifully refinished hardwood floors on the upper level, new wide plank engineered floors in the lower level, new electrical panel, updated plumbing lines, and all new appliances. A spacious and tranquil backyard sets the stage for perfect family gatherings and outdoor enjoyment. Close proximity to parks, public transit, shopping, and freeway access. Short drive to West Portals shops and dining, Tower Market, Starbucks, and Glen Park BART station
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
interior_features__c, Skylight(s);Wet Bar
ffd_lastmodifieddate, 2023-12-16T11:47:01.000+0000
pba__latitude_pb__c, 37.7383546
pba__latitude_property__c, 37.7383546
listed_date__c, 2023-10-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joseph
pba__listing_agent_lastname__c, Chav
listing_agent_mls_id__c, 805827
ffd_listingagentname, Joseph Chav
listing_agent_number__c, 166015886
listing_co_agent_mls_id__c, 355981
listing_co_agent_number__c, 355981
listing_co_office_mls_id__c, COLD03
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 875
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/jXSXtxkY4kg
pba__longitude_pb__c, -122.4464626
lower_level__c, Family Room,Garage,Primary Bedroom
mls_id__c, 423922223
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-11-10
original_price__c, 1395000
overall_days_on_market__c, -81762
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-11-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-12-15T17:28:23.000+0000
price_per_square_foot__c, 928.16
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000004eoWMAQ
room_type__c, Dining Room;Family Room;Primary Bedroom
sale_date__c, 2023-12-12
sale_price__c, 1615000
selling_agent_mls_id__c, EB91492
selling_agent_number__c, 981299250
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, KW Advisors East Bay
pba__status__c, Closed
pba__totalarea_pb__c, 1740
size__c, 1740
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Teresita
subdist__c, Miraloma Park
ffd_name, 566 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/530703352-1.jpg