meta_query='key:subdist__c;value:Miraloma Park|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='332168' 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, 140 Marietta Drive, San Francisco, CA, 94127
ffd_mls_id, 423738245
ffd_salesforce_id, a0E8W00000bc7IUUAY
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 140 Marietta Drive, San Francisco, CA, 94127
pba__address_pb__c, 140 Marietta Drive, San Francisco, CA, 94127
agent_only_remarks__c, OFFERS DUE TUESDAY, May 9th, by 3 pm. Please allow 24 hours for response as seller is out of State. SFAR contract please. Home is easy to show. On Supra lockbox AND keypad lockbox. Please text or call Bill at 415-309-7279 (NO emails please) if you need access via coded lockbox. Square footage includes the lower level room at approx 210 square feet.
architectural_style__c, Traditional
bath_features__c, Tub w/Shower Over;Shower Stall(s);Skylight/Solar Tube
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1943
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-05-01T17:48:34.000+0000
days_on_market__c, 79
dom__c, 9
ffd_description_pb, Located in desirable Miraloma Park, 140 Marietta Drive welcomes you to a pleasant 2 bedroom/2 bath home with a large family room and bonus room down. Enter into a good sized living room that has parquet floors. Follow the hall to the kitchen with newer cabinets and finishes, which opens to the permitted family room with fireplace and direct access to a spacious deck and large yard. Two good-sized bedrooms and two full baths, both with skylights, complete the main level. Down the stairs is a bonus room and direct access to the one-car garage, utility area, laundry, and rear yard. This delightful home is minutes from shopping, transportation, including BART, MUNI, the 101 and 280 Freeways, Miraloma Elementary School, Miraloma Playground and tennis courts.
district__c, SF District 4
driveway_sidewalks__c, Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced;Partial
fireplace_features__c, Wood Burning;Family Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2023-07-13T18:48:23.000+0000
pba__latitude_pb__c, 37.740528
pba__latitude_property__c, 37.740528
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2023-03-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, William
pba__listing_agent_lastname__c, Kitchen
listing_agent_mls_id__c, 803707
ffd_listingagentname, William J Kitchen Jr.
listing_agent_number__c, 803707
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 999000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.447978
lower_level__c, Bedroom(s),Street Entrance
mls_id__c, 423738245
main_level__c, Full Bath(s);Bedroom(s);Living Room;Family Room;Street Entrance
master_bathroom_features__c, Shower Stall(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-05-01
original_price__c, 999000
overall_days_on_market__c, -81569
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Facing Front,Interior Access,Workshop in Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2023-05-10
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1008.2
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bc7IUUAY
road_surface_type__c, Paved
sale_date__c, 2023-05-24
sale_price__c, 1230000
selling_agent_mls_id__c, EB308468
selling_agent_number__c, 981341633
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Redfin
pba__status__c, Closed
pba__totalarea_pb__c, 1220
size__c, 1220
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Marietta
subdist__c, Miraloma Park
ffd_name, 140 Marietta Drive, San Francisco, CA, 94127
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1943
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530611571-1.jpg