API tools faq
paste
Advertisement
Guest User

listings-sql

a guest
Oct 19th, 2017
2,432
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 227.65 KB | None | 0 0
raw download clone embed print report
  1.  
  2. CREATE TABLE `listings` (
  3. `id` int(12) NOT NULL,
  4. `owner_id` int(12) NOT NULL,
  5. `property_type` int(12) NOT NULL,
  6. `title` varchar(100) COLLATE utf8_bin NOT NULL,
  7. `description` text COLLATE utf8_bin NOT NULL,
  8. `yearbuilt` int(12) NOT NULL,
  9. `beds` int(11) NOT NULL,
  10. `baths` int(11) NOT NULL,
  11. `sleeps` int(11) NOT NULL,
  12. `sqfeet` int(12) NOT NULL,
  13. `lotsize` int(12) NOT NULL,
  14. `address1` varchar(255) COLLATE utf8_bin NOT NULL,
  15. `address2` varchar(255) COLLATE utf8_bin NOT NULL,
  16. `city` varchar(100) COLLATE utf8_bin NOT NULL,
  17. `state` int(12) NOT NULL,
  18. `zipcode` varchar(50) COLLATE utf8_bin NOT NULL,
  19. `latitude` varchar(50) COLLATE utf8_bin NOT NULL,
  20. `longitude` varchar(50) COLLATE utf8_bin NOT NULL,
  21. `created` int(12) NOT NULL,
  22. `updated` int(12) NOT NULL
  23. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  24.  
  25.  
  26. INSERT INTO `listings` (`id`, `owner_id`, `property_type`, `title`, `description`, `yearbuilt`, `beds`, `baths`, `sleeps`, `sqfeet`, `lotsize`, `address1`, `address2`, `city`, `state`, `zipcode`, `latitude`, `longitude`, `created`, `updated`, `id`, `listing_id`, `facility_id`, `category_id`) VALUES
  27. (1, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,473 sq ft.', 'Magazine ready on the inside and out, this Martha Stewart custom pool home is available today! Situated on a large 1/4 acre lot, no expense was spared on the gorgeous pool and patio area. It is complete with a large paver patio, salt water pool with Pebble Tec finish and sunshelf, huge screened-enclosed back porch, and additional tropical landscaping. Indoors, this Martha Stewart model offers upscale finishing touches such as the wainscoting in the foyer, formal sitting and dining rooms; upgraded Whirlpool appliances (including the washer & dryer); upgraded cabinets; granite counters in the kitchen; plantation shutters on the front of the house; and double pane low -E windows, radiant barrier roofing and Energy Star qualified appliances for that extra energy efficiency. The master bedroom has dark hardwood floors and the master bath features a seamless glass shower enclosure, dual sinks, and a garden tub. The secondary bedrooms have upgraded carpet while the rest of the home has oversized ceramic tile floors. Crisp lines, gorgeous colors, perfectly placed lighting, and functional details make this dream home a very real prize. Schedule a private tour and see what makes this home the start of something new. Call today! Note: This property is conveniently located only a few miles from Walt Disney resort and less than two miles from a Publix shopping plaza. Additionally, it is zoned for Windermere\'s notable school district. ', 2012, 4, 3, 0, 2473, 11058, '11719 Verrazano Dr', '', 'Orlando', 16, '32836', '28.43767', '-81.5539929\r', 1508462629, 1508462629, 1, 1, 8, 2),
  28. (2, 1, 1, 'Single Family Residential, 5 beds, 3.0 baths, 3,580 sq ft.', 'Traditional, eye-catching, and absolutely gorgeous, this two-story masterpiece offers five bedrooms, three bathrooms, a spacious upstairs loft, and a three-car garage. Common areas include separate living and family rooms, formal dining room, breakfast nook, and an open kitchen with an eat-in bar counter and upgraded counter tops and cabinetry. All these spaces interconnect, creating an efficient and friendly room flow while lighting, columns, and wall angles provide architectural interest. The ground floor holds all common areas, the huge master bedroom/master bath, a second bedroom, and bathroom. These areas have been covered with wood-grained tiles for beauty and versatility. The second floor is carpeted for comfort and holds three bedrooms, a full bathroom, and the loft. Outdoors, the front offers lovely curb appeal while the back offers a fenced-in lawn, open to the sun and stars, ready for any activity that brings added joy to your life. The beautifully landscaped community of Cypress Lakes offers its homeowners numerous amenities to include a community pool, clubhouse, exercise room, lakes with walking paths, basketball and tennis courts, playgrounds, and a dog park. It is located near grocery stores, restaurants, and convenient roadways to include State Road 408 and East Colonial Drive. Come see how very beautiful Central Florida can be. Schedule your private tour today! ', 2006, 5, 3, 0, 3580, 8752, '2743 Blowing Breeze Way', '', 'Orlando', 16, '32820', '28.5755978', '-81.1173986\r', 1508462630, 1508462630, 10, 2, 54, 5),
  29. (3, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,661 sq ft.', 'Sweet and inviting, this Orlando original owner property features an open and friendly space for easy living. With four bedrooms, three bathrooms, oversized kitchen, family room, separate living room, formal dining room, and two-car garage, this home offers a generous layout that allows for both versatility and comfort. Oversized bedrooms, upgraded stainless steel kitchen appliance package, well-maintained flooring to include tile, wood, and carpet, recently updated roof, and a extended pushed out garage also create elements of luxury and convenience. Outdoors, relaxation is at your beck and call with the backyard\'s spacious screen-enclosed lanai. Half of this area is shaded and equipped with an outdoor ceiling fan and half remains open to Florida\'s sun and stars, making this space ideal for both rest and activity. When out and about, the neighborhood provides its homeowners with private recreation to include a playground, swimming pool, tennis court, volleyball court, and basketball court. The community recreation area is only minutes away! Spacious and memorable on the inside and out, 332 Kassik Circle is ready and waiting for its new owner. ', 1994, 4, 3, 0, 2661, 0, '332 Kassik Cir', '', 'Orlando', 16, '32824', '28.3924717', '-81.3837161\r', 1508462631, 1508462631, 14, 3, 11, 2),
  30. (6, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 3,774 sq ft.', 'STUNNING POOL HOME! Enter the spacious foyer with access to the separate formal dining room and living room with crown molding. Continue into the gourmet kitchen featuring, an island work area with an abundance upgraded cabinets the kitchen has a pantry and second storage closet. No worries if the abundance of cabinets are not enough storage 2 additional storage closets off kitchen heading to garage. An informal dining with the perfect view of your amazing pool is also part of the kitchen. Office or additional bedroom down stairs along with a full pool bath leading out to the deck. Spacious family room with an extra-large sliding glass door leading out to the 25x 55 paver deck. The Salt water pool includes an oversized Jacuzzi and kiddy pool along with 2 Raised shear fountains for a relaxing retreat or, a great place to host a party. The pool also has a heat pump and a gas heater. Pool equipment replaced this year. Two stair cases lead upstairs to a huge activity room big enough to host a pool table and then some. Bonus room off of the activity room that is the perfect flex space as a theater room or exercise room or even a mother-in-law suite. The large master suite with its own private bath offering dual sinks, a Jacuzzi tub, & separate shower. The walk-in closet is amazingly oversized. The master suite also includes an inglenook that can be used as a nursery office or a reading room. Roof recently replaced 2012 hot water heater 1/2017 dishwasher garbage disposal 11/2016. Make an offer today. ', 2003, 4, 3, 0, 3774, 7566, '13513 Kitty Fork Rd', '', 'Orlando', 16, '32828', '28.5557105', '-81.1806477\r', 1508462632, 1508462632, 31, 6, 1, 1),
  31. (7, 1, 1, 'Single Family Residential, 5 beds, 3.0 baths, 2,786 sq ft.', '\" Short Sale ; approval of the seller\'s lenders(s) may be conditioned upon the gross commission being reduced. Any reduction of the gross commission will be apportioned between listing and cooperating brokers. Property need some repairs due to hurricane damage. Roof need to be repaired or replaced. ', 2000, 5, 3, 0, 2786, 5874, '13632 Tetherline Trl #4', '', 'Orlando', 16, '32837', '28.3650807', '-81.396916\r', 1508462632, 1508462632, 38, 7, 1, 1),
  32. (13, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,347 sq ft.', 'Nice 3 bedroom / 2 bathroom house in very nice community. Very low association fees per year and great for investment. Currently rented with a short time left on the lease. Call today for an appointment as this could be your next home!! ', 1990, 3, 2, 0, 1347, 6368, '839 Pond Cypress Ct', '', 'Orlando', 16, '32825', '28.5585577', '-81.2214916\r', 1508462635, 1508462635, 72, 13, 11, 2),
  33. (14, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,667 sq ft.', 'Beautiful home nestled in the historic heart of Kingswood Manor. Spacious rooms all through out and move in ready! Seller to confirm HOA and dimensions of rooms. ', 1961, 3, 2, 0, 1667, 10125, '5718 Eggleston Ave', '', 'Orlando', 16, '32810', '28.6139018', '-81.4034719\r', 1508462636, 1508462636, 80, 14, 1, 1),
  34. (16, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,225 sq ft.', 'DISCOUNTED FIXER UPPER IN THE WATERFORD/ AVALON/ UCF AREA!!! This diamond in the rough needs more than a little TLC but once the repairs are completed, it will be a gem for first time homeowner and investor alike. Situated on a little over 1/3 Acre, the opportunities for this property are endless. Highly desirable area. Like all good deals, this one might go fast so get out to see this property ASAP. Property will not qualify for traditional bank loans in current condition ', 1972, 3, 2, 0, 1225, 15994, '1735 Bonneville Dr', '', 'Orlando', 16, '32826', '28.5689901', '-81.1868646\r', 1508462637, 1508462637, 99, 16, 54, 5),
  35. (19, 1, 1, 'Single Family Residential, 3 beds, 2.5 baths, 2,024 sq ft.', 'Move in ready!!!! Great for the traditional family. Large and spacious inside and out. Sit in the family room with the wood burning fireplace or walk out the sliding doors to enjoy the scenic view of the backyard lined with fruit trees from the patio. Pool has a diving board and slide. Master bedroom includes a bathroom with large closet space. This spacious property will not last long. Bring your buyer today. ', 1969, 3, 3, 0, 2024, 10622, '3012 Sheringham Rd', '', 'Orlando', 16, '32808', '28.5831182', '-81.4603014\r', 1508462639, 1508462639, 115, 19, 1, 1),
  36. (20, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,875 sq ft.', 'Adorable and MOVE-IN READY! Single story, 4 bedrooms, 2 bathrooms, 2-car garage, brand new two-toned paint throughout! Bright and open floorplan with large sliding glass door exit to screened-in patio and nice size backyard with tons of potential! Eat-in kitchen showcases pantry space and island with 4-piece stainless steel appliances and breakfast bar! Nice size master bedroom complete with full, on-suite bathroom and nice walk-in shower. Three additional bedrooms and full bathroom complete this home. You do not want to miss this one! * Seller recently paid for a 3rd party complete home inspection(attached). Home Inspection is attached including all completed repairs. * ', 1999, 4, 2, 0, 1875, 9997, '2326 Archer Blvd #2', '', 'Orlando', 16, '32833', '28.5134792', '-81.0713604\r', 1508462639, 1508462639, 126, 20, 8, 2),
  37. (22, 1, 40, 'Townhouse, 2 beds, 2.5 baths, 1,176 sq ft.', 'Windsor Walk Two story townhouse with living and dining combo, eat in space in remodeled kitchen. Two master suites upstairs with walk in closets. Nice screen porch with storage unit and nice back yard. Huge community pool and club house on property. Inside laundry room and much more. ', 1988, 2, 3, 0, 1176, 1800, '11006 Regency Commons Ct', '', 'Orlando', 16, '32837', '28.408888', '-81.414872\r', 1508462641, 1508462641, 140, 22, 54, 5),
  38. (26, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 1,132 sq ft.', 'IF YOU ARE LOOKING FOR LUXURY AND VALUE YOU HAVE FOUND THE PERFECT RESIDENCE. WITH STUNNING LAKE EOLA VIEWS AND OVER $60,000 IN PREMIUM UPGRADES, THIS HOME IS AN INCREDIBLE INVESTMENT. PREMIUM STAGGERED TILE FLOORS WHICH EMULATE WOOD, CUSTOM LIGHTING, NEW PAINT, NEW CARPET, NEW TOP OF THE LINE BOSCH FRONT LOAD WASHER/DRYER, MOTORIZED SHADES IN ALL WINDOWS, CUSTOM CLOSET BUILT INS, AND CUSTOM DRAPERIES IN THE MASTER BEDROOM. IN ADDITION TO ALL THESE INCREDIBLE ADD ONS, THIS HOME HAS TWO PREMIUM SIDE BY SIDE PARKING AND ALSO AN OVERSIEZED TEMP CONTROLLED STORAGE UNIT ON THE 6TH FLOOR. OWNER IS WILLING TO SELL BELOW APPRAISED VALUE!!! THIS TOWER OFFERS THE MOST IMPRESSIVE AMENITIES OUT OF ANY LUXURY HIGH RISE IN DOWNTOWN ORLANDO WITH 24 HOUR SECURITY, BIO METRIC ACCESS, TENNIS COURTS, 5,000SF STATE OF THE ART FITNESS FACILITY, VALET PARKING, AND 5000 BOTTLE WINE VAULT. ', 2007, 2, 2, 0, 1132, 0, '150 E Robinson St #1607', '', 'Orlando', 16, '32801', '28.5452422', '-81.3764357\r', 1508462644, 1508462644, 160, 26, 11, 2),
  39. (27, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,502 sq ft.', 'COMPLETE RENOVATION AND DESIRABLE JESSAMINE TERRACE (292 acre recreational lake) Custom kitchen cabinets Custom quartz counter tops throughout All new stainless steel appliances Custom vanities with quartz counter tops in both bathrooms 100% water proof wood inspired flooring throughout New double-payne windows Complete electrical rewire New A. C. and ducts Pluming upgraded Recessed LED lighting AWESOME LOCATION minutes to downtown and to Sodo Give us a call for a showing today of a truly 2017 home! ', 1946, 3, 2, 0, 1502, 9303, '534 Kenmore Cir', '', 'Orlando', 16, '32839', '28.4790151', '-81.3811441\r', 1508462645, 1508462645, 171, 27, 54, 5),
  40. (28, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 2,031 sq ft.', 'This property is bank owned. It is sold in “as-is” condition without repairs or warranty. Buyer is responsible for verifying all information contained in this listing. ', 2005, 4, 2, 0, 2031, 5500, '2230 Darlin Cir', '', 'Orlando', 16, '32820', '28.5687008', '-81.1183464\r', 1508462645, 1508462645, 175, 28, 1, 1),
  41. (31, 1, 1, 'Single Family Residential, 4 beds, 2.5 baths, 2,970 sq ft.', 'CLASSY Highly Upgraded POOL & SPA Home on WATER with a Full Gourmet Summer Kitchen! Perfect landscaping with pavers on the driveway greet you at the front door of this resort style home. Located in the prestigious 24 hr. security gate guarded golf community of Stoneybrook. One BEDROOM DOWNSTAIRS with a bath. This is a 4 bedroom PLUS a bonus/game/theater room (approx. 19\' x 16\'). Bonus Room has a Built in very impressive Bar, has Hardwood in the dining & living room, hardwood laminate in all other rooms, kitchen & bathrooms ceramic, GRANITE in the kitchen & master bath. The Master Bedroom has an expansive Balcony which overlooks the pool & spa a Stunning view! The kitchen has two pantries, all Built In Closets throughout, laundry room Downstairs, larger (approx. 5\") baseboards, Crown Molding, SHUTTERS throughout the home. Full Gourmet Summer Kitchen with a kegerator, fridge, gas stove & T. V. Pool (saltwater) & spa are solar heated with Travertine pool deck & screened in overlooking the Water. GARAGE is a two car Extended garage. A/C three years old. All this in much sought after Stoneybrook East. Stoneybrook is renowned for its clubhouse, fitness center, resort style pool, playground, sports fields, tennis courts, walking trails, lush nature, golf vistas and TOP RATED SCHOOLS. Minutes to the Waterford Lakes Town Center, downtown Avalon Park, Research Park, Siemens, University of Central Florida, Medical City, Lake Nona, the Beachline (528) & the 408 East/West Expressway. ', 2003, 4, 3, 0, 2970, 5750, '2644 Dover Glen Cir', '', 'Orlando', 16, '32828', '28.516753', '-81.1619528\r', 1508462647, 1508462647, 195, 31, 8, 2),
  42. (37, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,704 sq ft.', 'Pre construction to be built. Price includes Lot, some Soft Cost, and Construction. Great opportunity to build a new home in a prime Orlando location. Wedgefield has all the best Florida has to offer: a championship 18-hole golf course and country club with restaurant and bar, bicycle lanes, community park, picnic pavilion, playground, ride horses, or simply enjoy Florida\'s natural beauty in the Hal Scott Preserve which provides over 20 miles of nature trails. Conveniently located within 20 minutes of Downtown Orlando, the Airport, I-95, Orlando attractions, UCF, Lake Nona’s \'Medical City\', or a short 30 min drive to the beach. Beautiful, large estate homes down the street. Call today to customize your new home. * Price of home will vary based on upgrades and square footage. Features and plans for models are attached. Buyer must be pre-approved for a construction to perm loan prior to arranging meeting with builder. Buyer and buyer\'s agent responsible for verifying taxes, fees, and measurements. ', 2018, 3, 2, 0, 1704, 44867, '. Caesar Ave #12A', '', 'Orlando', 16, '32833', '28.499617', '-81.086777\r', 1508462651, 1508462651, 238, 37, 11, 2),
  43. (47, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,962 sq ft.', 'Beautiful 4 bedroom, 3 Bath home located in the Bel-Aire Woods Subdivision. ', 1970, 3, 2, 0, 1962, 8805, '7017 Willowwood St', '', 'Orlando', 16, '32818', '28.5646552', '-81.4774352\r', 1508462655, 1508462655, 290, 47, 1, 1),
  44. (50, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 1,248 sq ft.', '.. .Move in ready. .. New interior paint for wall/door/baseboard/closet. New AC in May, 2017. This is 2 bedroom/2 bath condo with a separate Den/Loft that can be used as a 3rd bedroom. No water bill to pay, the homeowner association pays for your water. It is located in desirable Metrowest area. ', 1997, 2, 2, 0, 1248, 4553, '6316 Raleigh St #412', '', 'Orlando', 16, '32835', '28.526827', '-81.4683735\r', 1508462657, 1508462657, 311, 50, 8, 2),
  45. (51, 1, 1, 'Single Family Residential, 6 beds, 4.0 baths, 3,342 sq ft.', 'Beautiful spacious two story 6 bedroom 4 bathrooms, 3 car garage, pool home in the desirable Hunters Creek Community. Remodeled kitchen features brand new cabinets with crown molding, corian countertops, under mount sink, new faucet, stainless steel appliances & tile flooring. NEW ROOF 2015! COMPLETE RENOVATION THROUGHOUT THE HOUSE 2016! NEW AC 2017! COMMERCIAL FIRE SPRINKLERS! COMMERCIAL FIRE ALARM! ( Will significantly lower home insurance) Plenty of space to entertain family & guest in the large living & dining room, eat in kitchen & family room are all located on the first floor. First floor also features an enormous master bedroom with his & her closets, double tray ceiling, room for a sitting area, door leading to the pool area. Master bathroom features his & her sinks, marble countertops, soaking tub, walk-in shower & private water closet. First floor also features 4 guest bedroom, 2 guest bathroom & laundry room. Upstairs features a second master bedroom & a remodeled bathroom. French doors lead you to your backyard oasis, large salt water heated swimming pool, open patio area & property fence. NEW POOL PUMP. Pool has electric heater & solar panels. Screened in Florida room includes a ceiling fan, cable & electric outlets & AC system. A-Rated Elementary & Middle Schools. Conveniently located to SR417, SR528, Shopping, Dining & Disney. Community features tennis & basketball courts, parks, playgrounds, soccer fields! Hunters Creek listed as one of the best places to live per CNN Money Magazine. ', 1998, 6, 4, 0, 3342, 8654, '5137 Chelwyn Ct', '', 'Orlando', 16, '32837', '28.351045', '-81.4570517\r', 1508462658, 1508462658, 319, 51, 1, 1),
  46. (52, 1, 1, 'Single Family Residential, 4 beds, 4.5 baths, 2,842 sq ft.', 'Don\'t miss out on this great opportunity ! A spacious and cozy single family home on an oversized lot in WINGROVE ESTATES in DR. PHILLIPS. This home features a desirable split floor plan, 2,842 square feet of living space, 2 car garage, new AC Units; master bedroom with a very spacious walk in closet & a master bath with a Jacuzzi tub and a separate shower stall, 3 bedrooms, 4 full bathrooms and one half bath, formal dining room and living room , vaulted ceiling and a wood burning fireplace ; Wood Flooring in living, dining room and great room; ceramic tiles in wet areas and carpet in bedrooms. The bright kitchen provides stainless steel appliances, granite counter tops, raised-panel cabinets, built-in desk and a spacious breakfast nook, overlooking the screened in lanai, pool and spa. Wingrove Estates offers the ideal Dr. Phillips location, situated within close proximity to I-4, Downtown Orlando, Universal Studios, Sea World & Walt Disney World, the Grove shopping & dining complex and a short drive to Millenia Mall shopping center and Restaurant Row dining complex. Make your appointment for viewing it today ! ', 1989, 4, 5, 0, 2842, 14599, '8013 Winpine Ct', '', 'Orlando', 16, '32819', '28.4932254', '-81.4939335\r', 1508462658, 1508462658, 327, 52, 11, 2),
  47. (58, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 994 sq ft.', 'Investors and owner occupiers are going to love this condo in the city limits of Orlando! This well maintained La Costa Brava unit will not last long! Enjoy the luxuries of Lake Front Living on Lake Pineloch in the up and coming SODO district. This spacious END UNIT includes 2 bedrooms and 2 full bathrooms, lots of closet space, natural light and a large kitchen. Amenities of this lakefront complex include Lake Access, a Fishing Pier, Clubhouse with Kitchen & 2 community pools! Enjoy your water craft with the onsite boat ramp and boat dock. Private screened patio that overlooks an expansive greenspace and offers ample storage! Currently zoned for TOP RATED schools and conveniently located near all major roads, shopping, hospitals and restaurants. Just 5 minutes from Orlando Health, Dr. Phillips Performing Arts Center and Downtown Orlando. Don’t miss out on this opportunity. Call for a showing today! ', 1969, 2, 2, 0, 994, 7072, '726 E Michigan St #154', '', 'Orlando', 16, '32806', '28.5115048', '-81.3676574\r', 1508462662, 1508462662, 379, 58, 54, 5),
  48. (60, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,837 sq ft.', 'This beautiful three bedroom home with soaring ceilings and large rooms is conveniently located in the popular community of Country Run only minutes to shopping, dining, nearby schools and easy access for commuting all directions. The home has fresh interior and exterior paint and new carpets throughout all living areas and bedrooms. New stainless kitchen appliances will be installed. New roof is in the works and will be on prior to closing. Eat in space in the kitchen and a breakfast bar for entertaining. Spacious master suite with walk-in closet and garden tub will let you soak away your stress from the day. Inside utility room with full size washer/dryer hookups opens to the 2 car garage. Great location tucked away in a cul de sac for no pass thru traffic. Won\'t last long! Call today and get in before the end of the year so you can capture your homestead exemption for next year. ', 2001, 3, 2, 0, 1837, 9225, '7648 Fordham Creek Ln #4B', '', 'Orlando', 16, '32818', '28.5954256', '-81.485474\r', 1508462663, 1508462663, 390, 60, 11, 2),
  49. (65, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,827 sq ft.', 'This 4 bed, 2 bath split plan home has 1,827 sq. feet of great family living space including the garage conversation which is under air adds additional bonus room to this fabulous remodeled home. The interior and exterior has been freshly painted. New doors, closets doors, sliding door, baseboards, window treatments and new ceramic tile floor throughout. The kitchen has brand new cabinetry, counter tops, canned lighting installed, new lights fixtures and ceiling fans throughout. The two full bathrooms have had been completely renovated with tiles, tubs, plumbing fixtures, mirrors and vanities. Other improvements include new roof, new Hot Water tank, new Electrical panels, new gutters and new nest system to complement the newer A/C system. Located minutes away from the 408 you are just a quick drive to downtown Orlando, the University of Central Florida, Valencia College, and the shops and restaurants of Waterford Lakes. ', 1969, 4, 2, 0, 1827, 9447, '10934 Tangora St', '', 'Orlando', 16, '32825', '28.5581175', '-81.2256158\r', 1508462666, 1508462666, 422, 65, 1, 1),
  50. (68, 1, 40, 'Townhouse, 3 beds, 2.5 baths, 1,593 sq ft.', 'Beautiful townhome, 3 bed/2,5 baths, 1 car garage. Great Location, near to Lake Nona Medical City, conservation view. Nona Terrace is a quiet and quaint community that features the perfect lifestyle for young professionals and families with convenient access to all of the Orlando main arteries. Plenty of amenities: Basketball Court, Gated, Swimming Pool, Tennis Court, Tot Lot, Outdoor Fitness Area. ', 2013, 3, 3, 0, 1593, 3409, '10701 Savannah Landing Cir', '', 'Orlando', 16, '32832', '28.4141248', '-81.2335306\r', 1508462668, 1508462668, 441, 68, 8, 2),
  51. (72, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,473 sq ft.', 'The home of your dreams in the neighborhood of your dreams is Now Available!!! This Highly Upgraded Luxurious 4 bed / 3 bath pool home is located in Hunters Creek community. This beautiful oversized cul-de-sac lot has been meticulously maintained and features lush Florida landscaping. As soon as you walk in prepare to be amazed by the attention to detail throughout the home; from the crown molding, built in shelving, brand new Acacia engineered hardwood floors (with a 100 year transferable warranty), vaulted ceilings, and new energy efficient windows (Miami Dade Impact rated). Gorgeous Travertine floors, new stainless steel appliances (new Samsung Duo Flex Range w/ wifi & microwave convention oven), and granite counter tops. Kitchen nook overlooks the very spacious backyard and patio with huge screened in pool area - making this home perfect for entertaining. Pool has been recently resurfaced with pebble tec and new tile, also new safety net. This house has updated with up to code plumbing. The wonderful backyard pool not only has an amazing view of the pool but of the golf course as well. Conveniently located to 417 with plenty of nearby shopping, restaurants and medical services. Hunters Creek has been recognized by CNN Money Magazine as one of the top ranked communities to reside in the US with Top Rated Schools! Amenities include 7 private parks, tennis, basketball, volleyball courts, hiking trails and much more. This stunning home is a MUST SEE! ', 1989, 4, 3, 0, 2473, 15335, '3076 Zaharias Dr', '', 'Orlando', 16, '32837', '28.3614822', '-81.4157701\r', 1508462670, 1508462670, 475, 72, 54, 5),
  52. (73, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 1,024 sq ft.', 'WELCOME HOME TO THIS WONDERFULLY UPDATED AND MAINTAINED HOME. 3RD FLOOR GIVES YOU A BIRDSEYE VIEW. SPACIOUS BEDROOMS PLUS TONS OF CLOSET AND STORAGE SPACE. UPDATED KITCHEN WITH NEWER STAINLESS APPLIANCES. ELEVATOR PLUS UNDER THE BUILDING PARKING. WHAT MORE COULD YOU ASK FOR. 10 MINUTES TO DOWNTOWN AND NOT FAR TO THE BEACH. ', 1974, 2, 2, 0, 1024, 5265, '4141 Player Cir #522', '', 'Orlando', 16, '32808', '28.5911412', '-81.4308631\r', 1508462671, 1508462671, 478, 73, 8, 2),
  53. (74, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,400 sq ft.', 'Under Construction. Brand new very open floorplan, 4 bedroom, 3 bath with office Custom Home, 2400 sqft living, all stainless steel kitchen appliances included, upgraded faucets, 12\' ceilings, custom ceilings in master & office, 8\' tall doors, granite counter tops, custom 42\" cabinets with led lighting, crown molding, wood tile, ceiling fans in all 4 bedrooms, her\'s & his closets, 8\' tall garage door & much more. Estimated completion date October 20, 2017. ', 2017, 4, 3, 0, 2400, 10000, '2661 Babbitt Ave #6', '', 'Orlando', 16, '32833', '28.5069986', '-81.0746908\r', 1508462671, 1508462671, 486, 74, 1, 1),
  54. (76, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,191 sq ft.', 'Great home in convenient, desirable Autumn Pines. Nicely maintained home with 3 bedrooms, 2 full baths, garage and sliders open to large fenced back yard. You\'ll love the hurricane shutters throughout. Very nice split bedroom plan. Cul-de-sac street and sidewalks. Very centrally located near Goldenrod and Lake Underhill. You don\'t want to miss this one. Won\'t last. ', 1980, 3, 2, 0, 1191, 7568, '1213 Twin Cone Ct', '', 'Orlando', 16, '32822', '28.5316951', '-81.284585\r', 1508462672, 1508462672, 502, 76, 54, 5),
  55. (78, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,946 sq ft.', 'This Beautiful home is MOVE IN READY!!. Spacious 3 Bedroom 2baths with study single story home with 1941 SQFT. located in Beautiful Village Walk Community. This home offers 42\" Cabinets in Kitchen with Granite Counter top and bathrooms granite, Tile in all living space except bedrooms, and tile roof, paver drive way , paver walk way and much much more. At the center of neighborhood You will find the ideally situated 26000 SQFT towncenter. Clubhouse featuring gathering and multi purpose space, catering kitchen, mail room, and covered lanais, State of the art fitness center, Resort style swimming pool, Lap pool, Six Clay tennis courts, Basketball Court, full time community activity director , tot lot and more. ', 2015, 3, 2, 0, 1946, 6981, '12317 Regal Lily Ln #4E', '', 'Orlando', 16, '32827', '28.3863888', '-81.2664942\r', 1508462673, 1508462673, 514, 78, 54, 5),
  56. (79, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,255 sq ft.', 'Charming College Park bungalow completely updated. A must see! The home has been remodeled with beautiful finishes, dark bamboo flooring, chrome light and door fixtures throughout, a big kitchen with solid white shaker cabinets, exotic granite counter tops and new stainless steel appliances. Both bathrooms have been redone keeping the bungalow charm with subway tile in the guest bath and beautiful marble in the master shower. There are sliding doors in the kitchen that lead out to the covered screen porch and big back yard. Conveniently located close to shops & restaurants of downtown College Park, Orlando & Winter Park & within close proximity to schools, art centers, parks, hospitals & major highways. ', 1952, 3, 2, 0, 1255, 7007, '3201 Oberlin Ave', '', 'Orlando', 16, '32804', '28.5803772', '-81.3816186\r', 1508462674, 1508462674, 515, 79, 1, 1),
  57. (80, 1, 1, 'Single Family Residential, 4 beds, 3.5 baths, 3,530 sq ft.', 'Location, location and location. Over 3500 sqft of stunningly newer built 2-story pool home in the heart of Orlando-College Park. Voted one of the best neighborhoods in Orlando with its one of a kind boutiques, restaurants, spa experiences, local art, parks, golf course, yoga studios, classes in cooking, jewelry making and signature events throughout the year. In the fall, the main Drive is closed down for the College Park JazzFest, followed by other great events including Holiday on the Drive in December and Dancing on the Drive in the Spring. This open floor plan 4-bedroom 3.5 bath designer pool home with office and Gym is a must see. The Chef’s kitchen has it all: oversized granite island, breakfast bar, butler service area, built in wine rack, large pantry, 42’’ cabinets, gas convection range, and stainless steel appliances. This home is perfect for entertaining. Main floor has a built in second office space, exercise room, custom cabinet laundry room and the Master Suite equipped with large double sink vanity, soaker tub, walk-in glass shower and newly designed walk-in closet. Upstairs you will find 3 bedrooms, 2 baths and a large second living room/theater area. Beautiful backyard with a custom pool/spa, paver pool deck, pergola with lighting, privacy fence. Covered lanai with electronic screen, speakers for outside music and wired for a tv. Click on the virtual tour link to experience the beauty of this home. Schedule a showing today! ', 2013, 4, 4, 0, 3530, 10130, '1141 W Princeton St', '', 'Orlando', 16, '32804', '28.571329', '-81.396451\r', 1508462675, 1508462675, 522, 80, 8, 2),
  58. (82, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,612 sq ft.', 'EXCELLENT OPPORTUNITY TO OWN THIS PROPERTY IN THE AMAZING SOUGHT AFTER AREA OF WILLIAMSBURG. NO FENCES ALLOWED. A/C UNIT REPLACED IN 2010. ROOF REPLACED IN 2004. ALL APPLIANCES & 2 CAR GARAGE. WALKING DISTANCE TO CLUBHOUSE. ', 1982, 3, 2, 0, 1612, 6080, '10642 Larissa St', '', 'Orlando', 16, '32821', '28.4117051', '-81.4420556\r', 1508462676, 1508462676, 536, 82, 8, 2),
  59. (83, 1, 16, 'Condo/Co-op, 3 beds, 2.0 baths, 1,447 sq ft.', 'Spacious 3/2 condo in Gated Community at Stonebridge Commons. This 1447 sqft condo has a large living room and 2 walk-in closets, screened patio. The 3rd room with a french door can be used as an office. Community features are a resort style pool with spa, clubhouse, playground, tennis courts, and a fitness center. Metrowest is centrally located, close to shopping, dining, major highways, Universal Studios and Millennia Mall. Not a short sale or bank owned home. ', 2005, 3, 2, 0, 1447, 0, '2484 San Tecla St #204', '', 'Orlando', 16, '32835', '28.514496', '-81.4682554\r', 1508462676, 1508462676, 544, 83, 11, 2),
  60. (86, 1, 1, 'Single Family Residential, 3 beds, 1.0 baths, 1,094 sq ft.', 'You can own a 3 bedroom, single family home in downtown Orlando for $222,000. NEW roof in 2017! NEW Exterior paint in 2017! NEW Air Conditioner in 2016! Triple pane windows. Hardwood floors throughout. You can sit on the HUGE screened-in back porch and enjoy the corner lot that is adjacent to the highly desirable Lake Rowena neighborhood. This location is ideal. .. you can also walk to Audubon Park and the coffee shops, craft beer locations, weekly farmers market. ', 1953, 3, 1, 0, 1094, 7091, '2001 Virginia Dr', '', 'Orlando', 16, '32803', '28.5643347', '-81.3561368\r', 1508462679, 1508462679, 571, 86, 1, 1),
  61. (90, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,672 sq ft.', 'Well maintained & FULLY UPDATED 4 bed 2 bath PLUS office, bonus entertainment outdoor area to die for! 1700 SQ FT! Large pool resurfaced 2013 with PEBBLE TEC! NEW ENERGY STAR 2017 ROOF WITH PREMIUM RHINO UNDERLAYMENT , NEW A/C this week! RE-PLUMBED TOO! Tons of entertainment spaces in the backyard & front too! With Newly remodeled kitchen GAS STOVE!The largest kitchen you\'ll find, custom wood cabinetry, crown/trim! Built-in Island and double pantry cabinets. Completely re-designed for lots of cooking and entertaining! Top of the line Gas range and dishwasher! 3 large family rooms! new flooring, ship lap walls! Lots of Travertine floors and tile! INDOOR laundry room with extra FRIDGE AND PANTRY! Plenty of closets too! Beautiful very low maintenance landscaping and hardscape with virtually no grass so you can enjoy your time off laying around the pool with friends and family! Gutters entirely french drained underground to keep water away from the home. Solid Block Construction! So many thoughtful details too list! Candle Lite home builder. Slab is full terrazzo which is premium quality! Full camera security system. Covered side area to park a boat/motorcycles/trailer/ small RV. No HOA! Fully Fenced! Newer no maintenance Vinyl that lasts !This home can accommodate a large family and the kitchen is a dream! Nestled deep into the community on a very quiet street that homes rarely come up for sale. What a location! So close to FAMOUS Florida Mall, some of the best dining and shopping experiences! Disney Too! ', 1966, 4, 2, 0, 1672, 7360, '847 Linton Ave #5', '', 'Orlando', 16, '32809', '28.4605348', '-81.3889919\r', 1508462681, 1508462681, 604, 90, 11, 2),
  62. (101, 1, 1, 'Single Family Residential, 5 beds, 4.5 baths, 4,048 sq ft.', 'Stunning Palm floor plan that boasts a spacious gourmet kitchen with large center island, smooth granite countertops, stainless steel appliances, decorative range hood, butler pantry and large walk in pantry-- all open the oversized Family room with Bifold sliding doors! Secluded Master suite has enormous walk in closet and luxurious bath with soaking tub, separate shower and dual vanities. The Study or flex room or 6th bedroom on the lower lever has extra large walk in closet and bath. Upstairs offer 4 Large Guest suites surround the massive Game room perfect for family movie night or game time, huge upstairs kitchenette/bar with plenty of indoor storage. Also, one suite boasts a beautiful outdoor porch with a balcony!! Known for our energy efficient features, Meritage homes help you live a healthier and quieter lifestyle while saving you thousands of dollars on your utility bills. ', 2014, 5, 5, 0, 4048, 10500, '7927 Chilton Dr', '', 'Orlando', 16, '32836', '28.4120439', '-81.5028116\r', 1508462687, 1508462687, 674, 101, 8, 2),
  63. (104, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 2,298 sq ft.', 'Don’t miss out on this opportunity to live in Orlando’s beautiful historic district. Bring your personal touches and spice up this classic dream, or start fresh with a clean canvas and build your dream home with a view. This 3 bedroom 2 bath, 2298 sqft home built in 1940 not only has the best view of Lake Lancaster but it also has direct boat access right from your back yard. This property has a boat slip grandfathered in by the city of Orlando. Enjoy the convenience of this perfect location downtown which is close to everything and has easy access to public transportation. Schedule your showing today, because this gem won’t last long! ', 1940, 3, 2, 0, 2298, 10588, '1210 Briercliff Dr', '', 'Orlando', 16, '32806', '28.5273881', '-81.3637684\r', 1508462688, 1508462688, 698, 104, 54, 5),
  64. (109, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,508 sq ft.', '\"Location, layout and community. .. this home has it all. Located in the community of Azalea Cove, very near the 417/408, this 3 bedroom, 2 bath home features a formal living room, dining room/family room combination and full kitchen with breakfast bar. The kitchen includes all appliances with quiet run dishwasher, 42 inch cabinets, built-in/hidden waste basket and upgraded counter tops. There\'s also stainless, double sink, quartz back-splash and Moen faucet. The kitchen opens to the family room with volume ceilings and sliding glass door to the rear yard. The living room at the front of the home has French doors. There is an inside utility with cabinets and washer and dryer included. The living spaces feature neutral tile flooring with carpet in the bedrooms. The master bedroom feels very spacious with trey ceiling, his and her walk-in closets and dual sinks in the bath. Additionally, the home has separate meters for water irrigation, is pre-wired for alarm system, is pre-plumbed for water softener and includes blinds throughout. This one is a must see!\" ', 2012, 3, 2, 0, 1508, 5176, '7370 Azalea Cove Cir', '', 'Orlando', 16, '32807', '28.5589766', '-81.2882366\r', 1508462691, 1508462691, 729, 109, 54, 5),
  65. (112, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,260 sq ft.', 'You will fall in love with this move-in ready 1939 College Park bungalow, located in an area of growth and development close to restaurants and nightlife, and within a few minutes drive to all that downtown Orlando and Winter Park have to offer. When you enter the home, you\'ll notice the real plaster walls and stunning original hardwood floors, which have been recently stained and refinished. The kitchen and bathroom are newly remodeled with a contemporary feel. The home includes a large fence in backyard with a deck that is perfect for outdoor entertaining. An immaculate one-car garage features organizational built-ins, a work bench, and laundry area. ', 1939, 3, 2, 0, 1260, 6596, '226 E Harvard St', '', 'Orlando', 16, '32804', '28.570245', '-81.3742313\r', 1508462693, 1508462693, 749, 112, 1, 1),
  66. (117, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,375 sq ft.', 'Here comes 2,375 square feet of luxury living space situated on a beautifully landscaped lot on a cul-de-sac with a long 4-car-length driveway and inviting curb appeal. Open the entry door to a captivating view that goes all the way to the private pool oasis in the backyard. On your way you go through the family room with very tall ceilings open to the sweeping kitchen with separate breakfast area and serving bar. Formal dining area is directly connected to kitchen for ease of entertaining across the separate living room. Huge master bedroom and luxurious master bath with stunning natural and engineered stone finishes and separate large leisurely tub and separate shower. The split-design puts the other three bedrooms and two baths on the other side, for a total of 4 bedrooms and 3 full baths. You have a well shaded lanai, better than a pergola. The private custom designed pool makes you want to sit by the pool with a glass of wine and unwind. Occasionally, deer have been sited at front or back yards. ', 1995, 4, 3, 0, 2375, 12335, '4726 Amersham Ct', '', 'Orlando', 16, '32826', '28.60939', '-81.1763726\r', 1508462696, 1508462696, 781, 117, 1, 1),
  67. (121, 1, 40, 'Townhouse, 2 beds, 2.5 baths, 1,176 sq ft.', 'End Unit Townhome with 2 bedroom/2.5 bathroom in Windsor Walk! Owners have enhanced the home by installing tile in the entire unit, adding a new ac unit, new lights and plumbing fixtures, and painted the interior. The screened in lanai gives you plenty of room to entertain and relax! There is an outside storage closet off the patio. Both bedrooms upstairs have a full bathroom. Walk in closets in both bedrooms and a huge linen/storage closet is upstairs. Kitchen has an eat-in breakfast nook and a pass through to the living room. The kitchen has two pantries and ample cabinets. Washer and Dryer hook up inside downstairs off the kitchen. There are 2 assigned parking spaces outside of the home. Hurry--this unit won\'t last! ', 1990, 2, 3, 0, 1176, 2249, '11105 Alderly Commons Ct', '', 'Orlando', 16, '32837', '28.40761', '-81.41369\r', 1508462698, 1508462698, 803, 121, 54, 5),
  68. (123, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 1,268 sq ft.', 'The Jackson is a mid-century designed building located in Thornton Park. It is Urban Living at it’s finest. Walking through the front door you automatically are drawn to the large windows that define the space. This 2 bedrooms and 2 bath split floor is plan is located on the 5th floor with views looking south. The entire condo has had new wood floors installed. A fully equipped kitchen w/ granite counters, stainless steel appliances & solid wood cabinets. This unit comes with one secured parking space. This unit has been very well maintained, Excellent opportunity to own in Downtown Orlando. The Jackson conveniently located in the Heart of Thornton Park! Very close proximity to restaurants, bars, boutiques, Publix, & Lake Eola. ', 2006, 2, 2, 0, 1268, 20878, '525 E Jackson St #507', '', 'Orlando', 16, '32801', '28.5394046', '-81.370415\r', 1508462699, 1508462699, 810, 123, 11, 2),
  69. (126, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 1,853 sq ft.', 'Gorgeous 4 Bedroom, 3 Bathroom home nestled in highly sought after Lake Highland Park Neighborhood. Located in the Mills 50 District and walking distance to Ivanhoe Village and Virginia Drive’s boutiques and eateries! This beautifully maintained home is well appointed on larger lot and tree lined brick paved street. As you walk through the front door you will notice all the modern updates you are looking for while still honoring the charm of the original home. Bright Kitchen showcases brand new stainless appliances, granite counter tops and large eating space with wood burning fireplace. Second Wood burning fireplace sits at the centerpiece of the spacious Family Room. French Doors open to huge back yard with enough space for expanding the home or adding large pool and entertainment area. Additional 650 Square feet is located downstairs and is being used as Laundry and Utility Room. Space can easily be converted to meet your family needs such as; Play Room, Craft Area or Large Exercise Room. Walking distance to Lake Highland Preparatory School, minutes to Downtown, College park, Florida Hospital, Science Center and OMA. Park Lake/ Highland neighborhood recently was ranked as “Best Place to Live” in the Orlando Area by Niche website. This home will not last!! Make an appointment today for your private showing! ', 1946, 4, 3, 0, 1853, 11480, '704 Terrace Blvd', '', 'Orlando', 16, '32803', '28.5574724', '-81.3681965\r', 1508462700, 1508462700, 826, 126, 1, 1),
  70. (127, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 2,034 sq ft.', 'Wonderful 3/2 home in sought after Conway area with a fabulous addition gives this charminng residence tons of space and a flexible floor plan. The Backyard is a magical and serene sanctuary that feels as if you stepped out of a fairy tale with cobbled paths and brick patio areas to enjoy the beautiful & lovingly planted varieties of plants & trees, complete with a quaint shed & potting area. Upon entry is a large formal living room with an expansive picture window looking out onto the quiet street & front yard. To the right of the entry are two bedrooms & a large full bath w/ updated lighting & tub/shower combo. Further down the hall is the Master Bedroom Suite w/ a large closet and wonderful view of the beautifully landscaped private backyard. The Master suite includes an ensuite bath with a shower, upgraded vanity and backsplash. Plenty of living and entertaining space ! Kitchen features tons of cabinet and counter space , two huge closet pantrys with one currently set up as a coffee bar. All large appliances convey including newer refrigerator and cool retro range with double oven and griddle. Overlooking the kitchen is a large dining space that can be used as formal or informal as there is also an area in Great room that could be used for formal. The added HUGE Great Room is complete with cozy gas fireplace, French doors and ceiling fans. Also included is a bonus room off of the Great Room that could serve as an office, mudroom or use to fit your needs. Roof 2010. Electrical Panel updated. ', 1957, 3, 2, 0, 2034, 9105, '3103 Ivel Dr', '', 'Orlando', 16, '32806', '28.502992', '-81.3443186\r', 1508462701, 1508462701, 836, 127, 8, 2),
  71. (129, 1, 1, 'Single Family Residential, 3 beds, 2.5 baths, 2,510 sq ft.', 'LAKEFRONT with a PARK as your neighbor! Enjoy serene water views of East Lake in the Lake Nona area neighborhood of East Park. This premium homesite sits adjacent to a community park- AND has some of the longest views of the water to the rear. As you enter the home you are greeted by a 2-story living room and formal dining area, leading through to the large eat-in kitchen, where the glass sliding doors lead out into a covered porch- with park and lake views! In the back of the home is the private DOWNSTAIRS MASTER suite with more water views, and a master bath with lots of natural light, dual sinks, separate tub and shower, and a large walk-in closet. A downstairs family room leads out to the back lanai for peaceful sunrise coffee. Upstairs there are two bedrooms with a full bath, a nice loft area with views to the rear, and an upstairs utility room with laundry hookup, sink, and storage. This community has amenities such as tennis, basketball, volleyball, fishing pier, walking trails, playground, parks, and of course the lake! Live in the growing Lake Nona area with great schools, new restaurants, and shopping. Call today! ', 2005, 3, 3, 0, 2510, 6197, '10001 Lake District Ln', '', 'Orlando', 16, '32832', '28.422726', '-81.2367163\r', 1508462702, 1508462702, 847, 129, 1, 1),
  72. (131, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,948 sq ft.', '4 Bedroom , 2 Bathroom Home with a Private pool , Large Corner lot , Close to Orlando International Airport and Attractions . The fourth Bedroom can be used as an Office , The Home Offers a Large Master room with a 1/2 Inches Insulated ceiling Which Also Doubles as safe Room for hurricane/Tornado. In- ground 800 Gallon Salt Water with a new Hayward controller Installed in 2014. NO HOA fees . Seller will contribute with $5,000 towards closing cost * * * * . ', 1959, 4, 2, 0, 1948, 9996, '716 Santa Fe Ln #3', '', 'Orlando', 16, '32807', '28.5325876', '-81.2985163\r', 1508462703, 1508462703, 863, 131, 1, 1),
  73. (132, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,778 sq ft.', 'Come and check out this beautiful, four bedroom two bath home. Home is move in ready. It has a very spacious driveway, a cozy fireplace, a glistening pool in the backyard and a luxurious formal dining room. Master bedroom has a walk in closet and the kitchen is great for large family get togethers. Come see this home today, it will be gone quickly! ', 1964, 4, 2, 0, 1778, 9824, '5525 Gross Ct', '', 'Orlando', 16, '32810', '28.6134057', '-81.3990344\r', 1508462704, 1508462704, 873, 132, 1, 1),
  74. (135, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,664 sq ft.', 'GREAT FAMILY HOME WITH LARGE SCREEN ENCLOSED POOL. NEW WINDOWS AND FRENCH DOORS AND REMODELED KITCHEN. HOME SHOWS WELL AND PRICED TO SELL. NEAR SHOPPING, SCHOOLS AND MAJOR ROADS. ', 1987, 4, 2, 0, 1664, 8780, '2616 Bay Leaf Dr', '', 'Orlando', 16, '32837', '28.387093', '-81.4171129\r', 1508462705, 1508462705, 887, 135, 8, 2),
  75. (138, 1, 1, 'Single Family Residential, 3 beds, 2.5 baths, 2,057 sq ft.', 'CURTAIN RISING! This CHARMER located on a DOUBLE LOT in beautiful downtown Orlando is ready for YOU to call it home. Upon entering the foyer, this GEM is sure to take your breath away ! The home features a formal living room , formal dining room , a family room with a FIREPLACE, and a split floor plan. The REMODELED kitchen is a CHEF\'S delight and sure to impress boasting custom built cabinetry with lots of storage & hidden features, GRANITE countertops, a pantry, an island with an extended table, and stainless steel appliances. The large master bedroom suite is also sure to delight boasting enough space for a sitting area, GRANITE bathroom countertops, an oversized shower with a built-in bench , custom built his & her closets, and hidden storage features such as an ironing board and a laundry basket. .. . just to name a few! The large DOUBLE lot could be YOURS to sell in the future OR to add a pool and/or expand on your new home ! ? SPRING LAKE TERRACE is conveniently located in the HEART of \" The City Beautiful \" near highways for an easy commute, shopping , dining, and so much more! Call me today for more information and to schedule your private tour of this home! ', 1962, 3, 3, 0, 2057, 20000, '2146 Alameda Ave', '', 'Orlando', 16, '32804', '28.5566386', '-81.4095006\r', 1508462707, 1508462707, 916, 138, 54, 5);
  76. INSERT INTO `listings` (`id`, `owner_id`, `property_type`, `title`, `description`, `yearbuilt`, `beds`, `baths`, `sleeps`, `sqfeet`, `lotsize`, `address1`, `address2`, `city`, `state`, `zipcode`, `latitude`, `longitude`, `created`, `updated`, `id`, `listing_id`, `facility_id`, `category_id`) VALUES
  77. (140, 1, 40, 'Townhouse, 4 beds, 2.5 baths, 2,361 sq ft.', 'Tucked away within the desirable gated community of Woodland Terrace in Timber Springs, your beautiful 4 bedroom townhome has stunning updates and TRANQUIL POND VIEWS from living areas and bedrooms alike. TOUR THE HOME WITH THE VIDEO TOUR LINK. Modern in design, your first steps into the home’s front parlor will impress with GORGEOUS WOOD FLOORING. Head in to the heart of the home and you’ll find a picture perfect space for making memories with friends and loved ones. The gourmet kitchen shines with ELEGANT WHITE CABINETRY, STAINLESS STEEL APPLIANCES, MODERN GRANITE WITH UNDERMOUNT SINK, and a pop of color in the GLASS TILE BACKSPLASH. You’ll absolutely love preparing meals in the kitchen, enjoying your morning coffee in the breakfast nook or out on the screened-in patio, all with tranquil POND VIEWS and AIRY NATURAL LIGHT. Upstairs at the top of the rod iron banister a loft space awaits your future playroom, den, or upstairs game room. The 4 well-appointment bedrooms form a hub off this space. Imagine starting your day waking up to calming pond views from your master suite, then luxuriating in the SPA-LIKE FEEL of the REMODELED MASTER BATHROOM. The FRAMELESS GLASS SHOWER, large garden tub, double vanities, and double mirrored closets set a romantic mood. You’ll love everything about this house and neighborhood--and so will everyone else! Great schools, nearby shopping, & community amenities are what make it so desirable. Don’t delay! Come take a look before someone else claims your new home! ', 2007, 4, 3, 0, 2361, 2501, '515 Terrace Spring Dr', '', 'Orlando', 16, '32828', '28.535905', '-81.148482\r', 1508462709, 1508462709, 928, 140, 54, 5),
  78. (146, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,701 sq ft.', 'Traditional Sale - Wow, you won\'t want to miss the opportunity to own this move-in ready 1,700 sq-ft, four bedroom, two bathroom family home located within East Orlando\'s sought after Avalon Park community. This immaculate home has an open floor plan with ten foot ceilings and a great location with views from the back porch of the community pool, water and the conservation. The home has immediate curb appeal from the front and a rear entry two car garage and parking pad at the rear. As you enter the home you will love the open feel, flowing layout and will sure to be impressed by the all wood and tiled flooring. The floor plan features a living room with wood flooring and kitchen / dining room combo. The kitchen has granite counter-tops, 42\" cabinets, all major appliances included and both a central island for food preparation and a breakfast bar / serving hatch for entertaining. The dining area has sliding glass door access to the rear covered, screened porch with a wind down sun screen. The master suite has a good sized bedroom and en-suite bathroom with tub and separate shower stall. All bedrooms have tiled floors so perfect for those with allergies or pets. There is a utility room that leads into the large rear entry garage. This excellent location offers great school zoning and easy access to the local community shopping & restaurants as well as the Waterford Lakes mall, UCF and East coast beaches. Come enjoy the Avalon Park lifestyle. ', 2004, 4, 2, 0, 1701, 5658, '14344 Golden Rain Tree Blvd', '', 'Orlando', 16, '32828', '28.520864', '-81.1419944\r', 1508462712, 1508462712, 964, 146, 8, 2),
  79. (147, 1, 1, 'Single Family Residential, 4 beds, 3.5 baths, 3,440 sq ft.', 'Ski Lake waterfront home on Lake Price! Located on well over an acre, this gorgeous home has almost too many extras and upgrades to mention! Wonderful second floor balcony overlooking the natural landscape and incredible views of the lake, a pavered open deck below with a built in grill and seating, and a walkway to the lake and boat dock for your enjoyment! The interior also has many upgrades and features including the gourmet kitchen with 42\" cabinets, granite and stainless steel appliances, walk-in pantry and island/bar. The second floor private media room with surround sound is amazing! And there is a 20X14 bonus/game room/ that opens to the lake and balcony! There is tile and hardwood flooring throughout, crown molding, granite in the bathrooms and the master bath features a gorgeous garden tub, dual sinks, separate shower and his and her vanity areas. Secondary bedrooms are also generously sized, two car garage, upgraded ceiling fans and lighting, and upgraded and automatic lighted master bedroom closet. Located in small gated community that is convenient to UCF, Research Park, Oviedo, and 408, it would be a shame to miss this rare opportunity to own this gem on Lake Price! ', 2004, 4, 4, 0, 3440, 75461, '14125 Deep Lake Dr', '', 'Orlando', 16, '32826', '28.5925649', '-81.1752322\r', 1508462713, 1508462713, 971, 147, 1, 1),
  80. (149, 1, 1, 'Single Family Residential, 3 beds, 2.5 baths, 1,676 sq ft.', 'Wonderful neighborhood in the heart of Conway! Close to downtown, airport, & all major highways! Newer AC, water heater, plumbing and roof. Bring a little TLC and have a spectacular home ready for the holidays. This home has tile, wood laminate and bamboo floors throughout. Master bedroom is downstairs and has cathedral ceilings, large updated tiled shower and walk in closet. Upstairs has two additional bedrooms, one of which has double closets and private access to the upstairs bathroom. There is also a small loft area upstairs perfect for a media space. Off of the great room downstairs is a large screened in patio with a hot tub. Neighborhood has a community pool and tennis courts as well as highly rated schools - Conway Elementary, Conway Middle and Boone High School. ', 1986, 3, 3, 0, 1676, 5001, '2630 Waymeyer Dr', '', 'Orlando', 16, '32812', '28.515009', '-81.337933\r', 1508462714, 1508462714, 989, 149, 1, 1),
  81. (150, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,390 sq ft.', 'Beautifully remodeled home with 3 bedrooms 2 baths and a large pool with a big fenced in backyard, located in a quiet neighborhood. Home boasts a kitchen with new cabinets, countertops, and stainless steel appliances. Both bathrooms have been fully remodeled and walls have knockdown texture throughout. New laminate and tile floors throughout, and painted inside and outside with all new light fixtures. Yard landscape in the front. Come see this fully remodeled home today and bring an offer. ', 1963, 3, 2, 0, 1390, 10132, '2424 Sandy Ln', '', 'Orlando', 16, '32818', '28.5753195', '-81.4715974\r', 1508462715, 1508462715, 1000, 150, 54, 5),
  82. (153, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,525 sq ft.', 'Beautiful renovated corner property in highly desirable well maintained home. NO HOA. Move in ready, bonus room for 4th bedroom/media center. Pride of ownership shows at every angle. 5 mins to UCF and conveniently located to all Orlando has to offer. This one will not last! ', 1970, 3, 2, 0, 1525, 9841, '821 Park Manor Dr', '', 'Orlando', 16, '32825', '28.5560243', '-81.2283563\r', 1508462716, 1508462716, 1013, 153, 8, 2),
  83. (158, 1, 1, 'Single Family Residential, 2 beds, 1.0 baths, 841 sq ft.', 'Beautifully landscaped and welcoming front entrance to super cute home on quiet street, conveniently located in the Union Park/University area. Sitting on one-third acre and backing up to Jay Blanchard Park Trail, this charming 2BR/1BA bungalow has lots of potential and PLENTY of room to build on! Two enclosed porches and an additional screened lanai enclosure with separate workshop/utility room offer LARGER square footage than reflected in tax roll. Galley-style kitchen with custom wood cabinetry and trim work. Solid wood doors on closets and doorways. Hurricane awnings cover windows. Come see today! ', 1956, 2, 1, 0, 841, 14348, '11507 Bacon St', '', 'Orlando', 16, '32817', '28.5791344', '-81.2338986\r', 1508462719, 1508462719, 1047, 158, 11, 2),
  84. (160, 1, 1, 'Single Family Residential, 4 beds, 3.5 baths, 3,015 sq ft.', 'Toscana\'s BEST deal on a single family home, priced for quick sale and won\'t last long. More photos coming Sunday-Monday. This Venezia model has ceiling fans throughout, upgraded wood cabinets, 1st floor master suite and half bath, plus 3 bedrooms and 2 more full baths upstairs, along with a central loft area. This is an ideally located gated community right in the heart of Dr. Phillips near all the best dining, shopping, theme parks and a quick drive to downtown Orlando and Orlando Int\'l airport. Front lawn maintenance included in HOA. ', 2005, 4, 4, 0, 3015, 5517, '6827 Lucca St', '', 'Orlando', 16, '32819', '28.4605967', '-81.4755524\r', 1508462720, 1508462720, 1064, 160, 54, 5),
  85. (161, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,967 sq ft.', 'Clean and in move-in condition. Flexible floor plan. Fresh paint inside and out. Eat-in kitchen includes all appliances. Inside laundry room with washer and dryer. Fireplace in living room. Carpet replaced through out. Ceiling fans, screened porch and covered patio area. East Orlando location close to the 417, 408 and Florida Hospital East. ', 1983, 3, 2, 0, 1967, 10890, '230 S Shadow Bay Dr', '', 'Orlando', 16, '32825', '28.5418561', '-81.2606005\r', 1508462720, 1508462720, 1071, 161, 54, 5),
  86. (171, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,415 sq ft.', 'Located in the desirable Dr. Phillips area of southwest Orlando. Close to attractions, shopping, restaurants and top-rated schools. Situated on an oversize lot and overlooking lake White Pine, this lovingly cared for home is the perfect place to raise a family. Have your morning coffee on the screened porch while enjoying the few of the lake. Separate living, dining and family rooms offer plenty of space for entertaining. Call today to make your appointment to see this home. ', 1984, 4, 3, 0, 2415, 20436, '5844 Pitch Pine Dr', '', 'Orlando', 16, '32819', '28.4795652', '-81.4882496\r', 1508462725, 1508462725, 1127, 171, 54, 5),
  87. (181, 1, 40, 'Townhouse, 3 beds, 2.5 baths, 2,044 sq ft.', 'You must see this jewel in a GATED community in Avalon Park! You\'ll love the cherry laminate wood flooring, high ceilings, tall doors, renovated cabinets, newer appliances, french door, screened porch and the quiet and relaxing pond view. 3 bed/2 bath with dual sinks and garden tub in master bedroom, laundry room and a loft upstairs. Great schools and easy access to 408 and 417 highways. Make your appointment today! ', 2006, 3, 3, 0, 2044, 2520, '510 Terrace Spring Dr', '', 'Orlando', 16, '32828', '28.536319', '-81.148375\r', 1508462731, 1508462731, 1191, 181, 54, 5),
  88. (182, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 1,730 sq ft.', ' * * * MULTIPLE OFFERS - SELLER REQUESTS HIGHEST and BEST INCLUDING TERMS * * * REMODELED and MOVE-IN READY. You can\'t miss this opportunity! Located on a premium corner lot in an excellent location just off of Goldenrod between Colonial and University with easy access to shopping, UCF and toll roads. This home was lovingly cared for by its owner and features stainless steel appliances, granite countertops, hung insulated windows throughout, an additional brand new bathroom and closet that was added on - as well as a brand-new roof that was installed in 11/2014. You will enjoy a spacious split floor plan, a large living room & dining room combo with a unique, custom half-wall separation. Cool off after work on a hot sunny day in your sparkling 10\' deep, in-ground pool. Lounge around in your large back porch which is the full width of the home. Your future home features bamboo and terrazzo flooring, all upgraded bathrooms and a gas tankless hot water heater. This home is a gem and priced to sell. Do not delay, come make your offer today! ', 1964, 4, 3, 0, 1730, 9260, '2606 Bluebonnet St', '', 'Orlando', 16, '32807', '28.5798118', '-81.2859322\r', 1508462731, 1508462731, 1196, 182, 54, 5),
  89. (188, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,653 sq ft.', 'Welcome home to this beautiful mid-century Audubon Park pool home. Home was just recently painted on the exterior and has a new metal roof as of 2015. The large circular driveway with pavers gives much parking space for entertaining which leads into the gorgeous backyard and sparkling salt water pool area. A second separate backyard is perfect for pets and accessible through a separate door. The interior features refinished original hardwood floors, a large master bedroom with walk in closet, and remodeled kitchen with wood paneling ceiling for added character. The salt water pool has a screen enclosure for year round enjoyment and solar panels for heating. Home also has a fully equipped security system with 3 exterior camera\'s and electronic locks on every exterior door for added safety. Walking distance to the Audubon Park district and new Audubon Park (K-8) School which is \'A\' rated. ', 1956, 4, 2, 0, 1653, 10941, '1601 Falcon Dr', '', 'Orlando', 16, '32803', '28.5659307', '-81.3457499\r', 1508462734, 1508462734, 1221, 188, 8, 2),
  90. (190, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,042 sq ft.', 'Location, Location, Location!! This 3bedroom 2bath home has been attractively updated throughout. Kitchen features updated cabinets, NEW stainless steel appliances along with solid countertops. Freshly painted interior throughout and new carpet in bedrooms. Bright and airy floor plan with vaulted ceilings displays a spacious layout, allowing you to entertain comfortably. Master bedroom offers a walk-in closet and bath with tub/ shower. Other features includes stylish ceramic tile in main areas, New hot water heater, one car garage and newer roof. Oversized fenced in backyard is perfect in size. You will appreciate the convenient location, with being just minutes away from SODO, Downtown Orlando, shopping, dining, hospitals & medical offices. Easy commute to major highways and just minutes away from I-4, 408 and highly rated schools. Make your appointment today. ', 1987, 3, 2, 0, 1042, 4454, '2313 Marlboro St', '', 'Orlando', 16, '32806', '28.516176', '-81.355527\r', 1508462735, 1508462735, 1232, 190, 11, 2),
  91. (191, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,244 sq ft.', 'Solid block home off Central Florida Parkway. Original owner, extremely well kept. 3 bedrooms 2 baths, split plan. Brand new carpet, freshly painted. Corner lot, nice porch in back. 2-car garage. Convenient to 441, 423, 528 and turnpike. ', 1978, 3, 2, 0, 1244, 7951, '2343 Fawn Pl', '', 'Orlando', 16, '32837', '28.4103062', '-81.4104479\r', 1508462736, 1508462736, 1243, 191, 8, 2),
  92. (193, 1, 4, 'Other, 1 beds, 2.0 baths, 798 sq ft.', '\"Short Sale\" Great opportunity, GREAT LOCATION!!! Awesome location right next door to Disney on 400 acre lake Bryan. Million dollar views enjoy the Disney fireworks and fantastic lake views. Fully furnished turn key unit with rental management makes it so easy to own. Tommy Bahama decor with granite counter tops throughout, full washer and dryer, covered parking, security elevators with keyed access only. So many amenities, 3 heated pools, spa, kiddie pool, and workout facility. Scenic boardwalks, fitness center, game room, concierge service and meeting rooms. Management facility handles in-house rental program and check-in all so Close to all attractions: Disney World, Sea World, Epcot and upscale Mall At Millenia and many discount outlets close by. Location, Location, Location!!! Paradise Cove runs a water-sports complex on lake with all forms of water craft for rent and your vacation enjoyment. Restaurants are with-in a short walking distance form property and Tiki Hut at pool side and a putt putt golf course out front!! GREAT LIFE STYLE DESTINATION!!! ', 2006, 1, 2, 0, 798, 22669, '13415 Blue Heron Beach Dr', '', 'Orlando', 16, '32821', '28.3690037', '-81.5010465\r', 1508462737, 1508462737, 1264, 193, 54, 5),
  93. (198, 1, 1, 'Single Family Residential, 3 beds, 3.0 baths, 2,350 sq ft.', 'LOCATION, SPACE and STYLE! This gorgeous home is located in the desirable Lake Como area. Upon entering you are greeted by a formal living room boasting vibrant parquet floors. A beautifully UPDATED kitchen showcases butcher block counter tops with a separate island, an ample amount of solid wood cabinets for storage, a tile backsplash and stainless steel appliances all overlooking an eating space. The AMAZING layout of this home provides you with a TON of space. You’ll want to spend all of your spare time in the SPECTACULAR great room. The UNIQUE details of this space include an abundance of windows which allow the natural light to shine in, wood beams adorn the ceiling and Spanish tile graces the floor. French doors from the great room lead out to a huge fenced backyard, the perfect place for outdoor entertaining. Let\'s talk about the BONUS room! This amazing FLEX space could be also be used as a home office, a den or as the master bedroom if you desire, as it features private access to a full bathroom and the backyard. Three bedrooms are located on one wing of the house, the current owners using one of these with an en suite as their master bedroom. As you can see, the options for how you use the space in this home are endless! You’ll fall in love with the fantastic touches that make this house a HOME, like recessed lighting, crown molding and stylish woodwork. Situated in wonderful neighborhood with easy access to great local dining, shopping and major roadways, the only thing missing here is YOU! ', 1961, 3, 3, 0, 2350, 8253, '2727 Dellwood Dr', '', 'Orlando', 16, '32806', '28.5293063', '-81.3481273\r', 1508462740, 1508462740, 1292, 198, 8, 2),
  94. (200, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,027 sq ft.', 'Come see this 3 bedroom 2 bath home nestled in the popular Grant Station subdivision. The garage was converted to the 3rd bedroom. There is a small portion of the garage left used as a storage closet, and the garage door functions normally. Comes with a six camera security system for your peace of mind. All new windows in the house. Fresh paint inside and out. New carpet and laminate floor. Newer dishwasher. Features a fenced yard and the community has a park and walking trail. Minutes from SR 408, Downtown Orlando and Winter Park. Let the house speak for itself and come see it today! ', 1984, 3, 2, 0, 1027, 3816, '2222 Faxton Ct', '', 'Orlando', 16, '32812', '28.5177761', '-81.3156829\r', 1508462741, 1508462741, 1301, 200, 1, 1),
  95. (201, 1, 47, 'Vacant Land, 0 beds, baths, 0 sq ft.', 'Looking to build a home on a piece of water front property? This beautiful 1 1/3 acre lot located in Wedgefield on Somerset Street is a perfect place for someone to build their very own custom home. Very closely located to 528, 520 and state road 50. Only 15 minutes from the Orlando International Airport! Also near by is the Wedgefield Country Club. Come see this beautiful piece of property today and do not miss the chance to build your very own DREAM HOME! ', 0, 0, 0, 0, 0, 57935, 'Somerset St #7A', '', 'Orlando', 16, '32833', '28.454834', '-81.086845\r', 1508462742, 1508462742, 1312, 201, 54, 5),
  96. (210, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,285 sq ft.', 'A beautiful home in a great location! Move-in ready, excellent floorplan. New paint. This home is in the gated community of Tudor Grove at Timber Springs and backs up to a conservation area. It\'s close to everything: UCF, restaurants, shopping and attractions. ', 2006, 4, 3, 0, 2285, 11959, '16425 Tudor Grove Dr', '', 'Orlando', 16, '32828', '28.5374257', '-81.1374479\r', 1508462747, 1508462747, 1367, 210, 1, 1),
  97. (211, 1, 1, 'Single Family Residential, beds, baths, 0 sq ft.', 'Address is estimate to assist in finding the property. This lot appears to be free of wetlands, but an inspection always needs to be made. ', 0, 0, 0, 0, 0, 48351, '18193 Robertson St', '', '', 16, '32833', '28.4637514', '-81.1087375\r', 1508462748, 1508462748, 1372, 211, 1, 1),
  98. (213, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 976 sq ft.', 'CALLING ALL INVESTORS!! This 2 Bedroom 2 Bath condo is the perfect investment property. The community is conveniently located near major transportation and is a short walk to the local grocery store. Mall at Millenia and other shopping venues are less than 3 miles away! The community features a community pool, playground, and is gated. Call now to schedule your private tour! ', 1973, 2, 2, 0, 976, 5933, '4755 S Texas Ave #D', '', 'Orlando', 16, '32839', '28.4932051', '-81.4091835\r', 1508462749, 1508462749, 1389, 213, 8, 2),
  99. (214, 1, 1, 'Single Family Residential, 6 beds, 3.0 baths, 2,808 sq ft.', 'Two story home with five bedrooms and three baths. Large family room with tile flooring. Popular open kitchen design with lots of natural lighting and breakfast bar. Master bedroom has french doors with own bathroom that has double sinks and garden tub. Open patio in back, large yard with mature trees. Large attached garage. ', 2003, 6, 3, 0, 2808, 9528, '1963 Marsh Hawk Dr', '', 'Orlando', 16, '32837', '28.3581936', '-81.3977725\r', 1508462749, 1508462749, 1396, 214, 11, 2),
  100. (219, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 2,008 sq ft.', 'Don\'t miss this perfect four bedroom two bath home nestled in Stonebriar. This gorgeous home boasts over 2,000 square feet for your family to enjoy. Walk in and relax in your formal living room, accented with crown molding which also carries into the master bedroom. Step through the arched doorway into your beautiful upgraded kitchen featuring 42\" solid wood cabinets, granite counter tops, stainless steel appliances, an island, and tile back splash. The open concept kitchen, dining area, and family room with pre-wired sound system provides the perfect space for family and friends to gather. Retire into your master suite which was custom designed. It includes not only a stunning bathroom with solid wood cabinets, a garden tub, separate glass shower stall, but also a bonus room with french doors that can be used as a nursery or office! Additional features include a rare extended garage and a privacy fence that extends to cover the side windows! This home really does have it all. Located in the same subdivision as East Lake Elementary and just minutes from UCF! Schedule your showing today before this one is gone! ', 2008, 4, 2, 0, 2008, 6299, '4212 Feldspar Trl', '', 'Orlando', 16, '32826', '28.5979431', '-81.1661198\r', 1508462752, 1508462752, 1431, 219, 11, 2),
  101. (224, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,456 sq ft.', 'Here\'s your chance to purchase this fixer-upper and renovate it to your liking. Homes similar to subject property are selling for $20,000 to $35,000 after repairs. This home is ideal for the family that wants to purchase and renovate their home to their own liking or for the investor that wants to fix & flip or fix & hold. Zoned for an \"A\" Rated High school & \"A\" Rated Elementary School. Home is located in a highly desirable area with close proximity to all highways (FL Turnpike, Highway 528, Highway 417, Osceola Parkway & within 10 minutes to International Drive, 20 Minutes to Downtown & 5 minutes to Mega Shopping Plazas such as The Loop & The Crosslands. Take a 5 minute drive to over 150 shops, restaurants, markets, movies, etc. ', 1982, 3, 2, 0, 1456, 7506, '2141 Allspice Ave', '', 'Orlando', 16, '32837', '28.3919811', '-81.4078116\r', 1508462755, 1508462755, 1471, 224, 11, 2),
  102. (226, 1, 1, 'Single Family Residential, 4 beds, 2.5 baths, 2,862 sq ft.', 'Enjoy the Central Florida Lifestyle, in this 4 bedroom/2.5 bath single family home in the desirable community of Hunters Creek. This home features an open floor plan with volume ceilings and neutral paint tones throughout. The downstairs offers a spacious great room, den/office and family room with fireplace and half bath. The master bedroom and bath is situated upstairs; featuring dual sinks, a jetted tub, separate shower and water closet. The kitchen features stainless steel appliances and new granite counters. Extend your living area outdoors with a covered lanai and fenced yard for added privacy – no rear neighbors. A home designed with the active family in mind, enjoy the amenities of Hunters Creek, i. e. park/playground, tennis and basketball courts along with soccer fields. Conveniently located to shopping, restaurants, area attractions, medical and major roads. ', 2002, 4, 3, 0, 2862, 6002, '5154 Terra Vista Way', '', 'Orlando', 16, '32837', '28.3595785', '-81.4568929\r', 1508462756, 1508462756, 1481, 226, 11, 2),
  103. (228, 1, 1, 'Single Family Residential, 3 beds, 1.0 baths, 1,562 sq ft.', 'Charming bungalow home in downtown Orlando. Minutes to everything. Wood floors throughout the home and everything updated! Newer A/C unit less than 3 years old with upgraded insulation. Fenced backyard with screen patio area and plenty of room for the family or pets. Carport area for the car that is extra deep. Less than 5 minutes from downtown Orlando and close to restaurants, SODO shopping and minutes to I4, 408 and the 417. ', 1949, 3, 1, 0, 1562, 10770, '224 W Illiana St', '', 'Orlando', 16, '32806', '28.5107713', '-81.3811484\r', 1508462757, 1508462757, 1499, 228, 11, 2),
  104. (233, 1, 1, 'Single Family Residential, 3 beds, 1.0 baths, 1,100 sq ft.', 'Three bedroom , 1 bath home with 1 car carport and fenced in yard. Original hardwood parquet flooring throughout with light and bright Florida room. The carport is just off the kitchen with a laundry room and storage space with easy covered access from the house. Downtown living in walking distance to shopping, restaurants, and entertainment and the the downtown YMCA. And a short bike ride to Thornton Park, the Milk District and downtown Orlando. Easy access to the 408 and I-4. ', 1955, 3, 1, 0, 1100, 8750, '2107 Mount Vernon St', '', 'Orlando', 16, '32803', '28.5506462', '-81.3548142\r', 1508462760, 1508462760, 1527, 233, 8, 2),
  105. (235, 1, 1, 'Single Family Residential, 3 beds, 2.5 baths, 2,077 sq ft.', 'You won\'t find another home like this one, she boasts beauty, brains, and is easy on the wallet! A keeper for sure. The beauty is evident at first sight with an abundance of curb appeal, an enhanced landscape package, stone accents, brick pavers and a wonderful conservation-view. Check out the brains on this one! Smart features include a Nest thermostat, Q-See cameras, Rachio programmable irrigation system, and garage door openers which can all be controlled by your smartphone. For those who enjoy saving thousands of dollars per year, you\'ll love the Tesla Powerwall System consisting of 32 rooftop solar panels that charge 2 Tesla Powerwalls capable of powering your entire home completely independent of the power grid. This means zero to ultra-low power bills month after month, year after year. In addition, the garage has been outfitted with a 220-volt electric car charging outlet. If these attributes were not enough, the attractive features of this home and community will surely seal the deal. First, is a 3-car tandem garage. Next, is a stunning kitchen with 42\" cabinets, brushed nickel hardware, quartz countertops, and stainless steel appliances. The floorplan is excellent with an open concept kitchen and living room, a large flex room that may be used as a formal space or office, and all bedrooms are upstairs along with a loft and laundry room. The Randal Park community is located in the Lake Nona corridor and amenities include fitness center, swimming pool, walking trails, and playgrounds. ', 2017, 3, 3, 0, 2077, 6103, '8549 Lovett Ave', '', 'Orlando', 16, '32832', '28.442612', '-81.235367\r', 1508462761, 1508462761, 1542, 235, 54, 5),
  106. (236, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,119 sq ft.', 'SHORT SALE! A little TLC will make this a great home or investment opportunity and NO HOA! Minutes from Orlando International Airport, Downtown Orlando, and Lake Nona Medical City Area. ', 1994, 4, 2, 0, 1119, 3958, '7418 Hollow Ridge Cir', '', 'Orlando', 16, '32822', '28.5074684', '-81.2884833\r', 1508462761, 1508462761, 1544, 236, 11, 2),
  107. (240, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,030 sq ft.', 'Remodeled home, which features porcelain tile flooring in bathrooms and kitchen and the rest is hard wood flooring, granite counter tops in kitchen and bathrooms, new windows, new wood shaker cabinets in bathrooms, front and back porch, new lighting, freshly painted inside and outside, and so much more. Located near shopping and highways. Make this home your dream home. ', 1901, 4, 3, 0, 2030, 9304, '3540 Lake St', '', 'Orlando', 16, '32806', '28.5031692', '-81.3736887\r', 1508462764, 1508462764, 1569, 240, 1, 1),
  108. (242, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,827 sq ft.', 'Remodeled pool home, which features porcelain tile flooring in bathrooms and kitchen and the rest is hard wood flooring, granite counter tops in kitchen and bathrooms, new stainless steel appliances, new wood shaker cabinets in bathrooms and kitchen, new windows, covered large front porch and brick walkway and screened in back porch, new lighting, new paved driveway, freshly painted inside and outside, partial view to lake, and so much more. Located near shopping and highways. Make this home your dream home. ', 1964, 3, 2, 0, 1827, 19282, '313 Jennie Jewel Dr', '', 'Orlando', 16, '32806', '28.5029121', '-81.3738581\r', 1508462765, 1508462765, 1590, 242, 54, 5),
  109. (246, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,601 sq ft.', 'The original 1946 home was totally renovated in 1999 to a 1,700+ SF 3/2 bungalow with vaulted ceilings in Living Room, Dining Room and Master Bedroom. Features include a 13’ x 16’ traditional open beam design wood screened porch nestled under mature Oak trees, an 18’ x 22’ porte cochère and a 6’ x 24’ covered front sitting porch. This home is located in the midst of Downtown Orlando Thornton Park with a City dog park just 1½ blocks away, plus multiple lakes and parks in the Lake Cherokee/Lake Davis area. Orlando Regional Medical Center and Downtown Orlando are just a few blocks. The oversized lot is permitted for construction of a separate 1,444 SF garage apartment. ', 1947, 3, 2, 0, 1601, 8998, '529 S Summerlin Ave', '', 'Orlando', 16, '32801', '28.535608', '-81.3680229\r', 1508462768, 1508462768, 1617, 246, 1, 1),
  110. (252, 1, 16, 'Condo/Co-op, 2 beds, 2.5 baths, 1,459 sq ft.', 'Walk out your font door onto the streets of Downtown! This brownstone style home is for the owner who enjoys true city living. Walking distance to everything Downtown Orlando from dining and entertainment to Lake Eola. Literally across the street from the Dr. Phillips Performing Arts Center. This luxury townhome condo is one of 11 units of its kind in the entire building. This spacious townhome has all the upgrades at at incredible price! It offers a dual window system throughout for sound proofing, Samsung stainless steel appliances, modern kitchen, new wide­planked laminate wood floors, ceramic tile, crown molding, blinds, and newer A/C unit 2013. The community offers a resort style pool, bbq area, and large fitness center. THIS UNIT COMES WITH 2 VIP PARKING SPACES ON THE FIRST FLOOR OF THE PARKING GARAGE. Come see this today! ', 2002, 2, 3, 0, 1459, 93940, '204 E South St #1053', '', 'Orlando', 16, '32801', '28.5373818', '-81.3755292\r', 1508462771, 1508462771, 1655, 252, 11, 2),
  111. (257, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,630 sq ft.', 'This is a great starter home in the Dr. Phillips/Bay Hill area of SW Orange County. The home is move in ready and features 3 bedrooms, 2 bathrooms and a 2 car garage. Home has an open floor plan cathedral ceilings in the living room, a large breakfast bar and tile flooring throughout the home. Master bedroom has a spacious walk-in closet and sliding glass doors leading to the back patio. Two guest bedrooms have generous closets and the hall bath has tub with shower. The home is zoned with desirable schools well known in Orange Co. include Dr. Phillips Elementary, Southwest Middle School & Dr. Phillips High School. This home is close to Universal Studios, Sea World, Disney World and many shops & restaurants. Convenient community living at its very finest in a established & desirable Florida location. ', 1980, 3, 2, 0, 1630, 11030, '7627 Clubhouse Estates Dr', '', 'Orlando', 16, '32819', '28.456595', '-81.4979539\r', 1508462774, 1508462774, 1684, 257, 11, 2),
  112. (259, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,370 sq ft.', '3 bedroom, 2 bathroom beauty in Hiawassee Point, just a quick drive to Lake Orlando Golf Club, Forest Lake Golf Club of Ocoee, Lake Apopka and so much more! Step inside to see that this home features vaulted ceilings, tile throughout the kitchen, living and dining areas. Kitchen opens to the dining area for quick breakfasts before work or school. Living room is spacious and cozy, a wonderful place to spend time with the family. Master suite features a large window creating a cheery atmosphere, as well as a walk-in closet and private bathroom with soaking tub, separate shower and dual sinks. This one won’t last long, stop by today! ', 1988, 3, 2, 0, 1370, 6212, '3705 Narroline Dr', '', 'Orlando', 16, '32818', '28.590456', '-81.473703\r', 1508462775, 1508462775, 1693, 259, 1, 1),
  113. (266, 1, 1, 'Single Family Residential, 2 beds, 2.0 baths, 1,120 sq ft.', 'All offers are subject to lender\'s approval. ', 1982, 2, 2, 0, 1120, 6921, '6923 Firebird Dr', '', 'Orlando', 16, '32810', '28.6245701', '-81.4250075\r', 1508462778, 1508462778, 1732, 266, 8, 2),
  114. (267, 1, 1, 'Single Family Residential, 5 beds, 3.5 baths, 2,993 sq ft.', 'Beautiful 5 bed/3.5 bath home near UCF. Plenty of room for everyone without being on top of each other! Downstairs features an open formal living/dining room, an enormous kitchen with room for a table and chairs, an oversized family room, powder room and large screened porch. Upstairs you will find all the bedrooms. Oversized master bedroom features 3 closets (two walk-ins), garden tub, shower, and double vanity. A second master-style bedroom has walk-in closet and attached bath. Two additional bedrooms share a hall bath and a small fifth bedroom works well as an office space. Washer/dryer included. Two Brand New A/C Units. as well as fresh outside paint within the last year ', 2003, 5, 4, 0, 2993, 5261, '13813 Econ Woods Ln', '', 'Orlando', 16, '32826', '28.5765925', '-81.1781749\r', 1508462779, 1508462779, 1737, 267, 8, 2),
  115. (268, 1, 16, 'Condo/Co-op, 3 beds, 2.0 baths, 1,318 sq ft.', 'This is one of the best condos in the area, beautiful upgraded move-in ready second floor 3 bedroom 2 bathroom condo with pond view perfectly located in Gated Cypress Fairways community. This unit features a spacious floor plan, wood floor, beautiful upgraded kitchen with granite countertops, breakfast bar, stainless steel appliances, master bedroom with walk-in closet, full size washer/dryer. The community of Cypress Fairways features a walking trail, clubhouse with fitness center, business center and wet bar, on-site car wash, one of the pool is with lush landscaping and waterfall, lighted tennis courts, playground & multiple BBQ areas. Minutes to Universal Studios & the Mall at Millennia, plenty of shopping, and dining establishments, with quick access to I-4 and Turnpike. Call us today to schedule a showing. EASY TO SHOW! ', 2000, 3, 2, 0, 1318, 16772, '5467 Vineland Rd #6208', '', 'Orlando', 16, '32811', '28.4853307', '-81.4523212\r', 1508462779, 1508462779, 1747, 268, 11, 2),
  116. (271, 1, 40, 'Townhouse, 3 beds, 2.5 baths, 1,994 sq ft.', 'Stunning Waterfront townhouse in award winning man guarded community of Vizcaya in the heart of Dr Phillips. This gorgeous 3 bedroom 2 and a half bath , 2 car garage, END UNIT home features incredibles views of Lake Serene with a private deck and screened in patio for you to enjoy the outdoor living that Florida provides year round. This beautiful home is full of upgrades including hardwood floors , gas fireplace in main family room, stainless steel appliances and upgraded wood cabinets. The master bedroom includes a his / her walk in closet & private balcony with a breathtaking view of the lake. The master bath features dual sinks & Spa/Hydro Massage tub with separate shower stall. There is another 2 large two bedrooms with a jack and jill bathroom and beautiful multipurpose loft in the second floor. Ideal location in the heart of Dr. Phillips, with top rated schools and Restaurant Row just minutes away. ', 2002, 3, 3, 0, 1994, 4074, '8216 Tivoli Dr', '', 'Orlando', 16, '32836', '28.444626', '-81.498806\r', 1508462781, 1508462781, 1765, 271, 11, 2),
  117. (272, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,659 sq ft.', 'Welcome to the recently remodeled 1027 Meadows Ave in College Park. You are going to fall in love with the beautiful open kitchen, salt-water pool, and master bedroom, bathroom and laundry room renovation. There are two family rooms, one off the kitchen and the second family area is perfect for a playroom, office or a TV room. Just steps away from Bishop Moore High School, St. Charles and less than a minute from everything College Park has to offer, giving you prime College Park location. Easy access to all major highways, minutes to Downtown Orlando and Winter Park and only 15 minutes from the Orlando International Airport, the days of sitting in traffic are over. Upgrades include Riannai tankless water heater, stainless steel appliances, pebble-tec pool surface w/ gas heater. New irrigation system, new HVAC System throughout, 2014 remodeled kitchen with quartz counters, Kohler cast iron farmhouse sink and 2017 Whirlpool french door refrigerator. Remodeled master bath with Silestone quartz counters, plantation shutters throughout and original hardwood floors. This house is remodeled, renovated and in perfect condition. ', 1954, 3, 2, 0, 1659, 6301, '1027 Meadows Ave', '', 'Orlando', 16, '32804', '28.5909398', '-81.3957543\r', 1508462782, 1508462782, 1773, 272, 8, 2),
  118. (274, 1, 16, 'Condo/Co-op, 1 beds, 1.0 baths, 945 sq ft.', 'HUGE PRICE REDUCTION!! SELLER VERY MOTIVATED!! On this Beautiful 1 bedroom with a Den Condo in the middle of it all!! this condo comes with an amazing renovated kitchen with Granite counters, tile back-splash, dark cabinetry with Stainless Steel Appliances. Roomy Master Bedroom with HUGE walk in Closet. Tray ceilings in the Living area with crown molding. A study nook and wood looking flooring thru out. Experience RESORT STYLE LIVING in one of Orlando\'s most Picturesque areas. 15 Min from downtown and Disney. 10 Min from the Mall at Millennia & Turnpike, few minutes to Universal Studious. This Gated Community w/ 24HR Guard post, has a Village Square with convenience store, an expansive 4000 sq ft work out center and restaurant Bar & Grill. 2 Swimming pools both w/ hot tub Jacuzzi, indoor climate controlled Basketball/Volleyball court, Residence Club w/ billiard tables , Business Center, walking trails along Turkey Lake, Boat Ramp, Fishing Pier, and BBQ/Picnic areas along the lake and throughout the community. MAKE AN OFFER NOW! * Please confirm HOA fees, HOA rules, Room sizes are approximates * ', 2000, 1, 1, 0, 945, 11834, '3344 Corona Village Way #303', '', 'Orlando', 16, '32835', '28.507901', '-81.4754625\r', 1508462783, 1508462783, 1784, 274, 8, 2),
  119. (275, 1, 1, 'Single Family Residential, 4 beds, 3.5 baths, 2,886 sq ft.', 'Quite simply the best opportunity in Lake Nona. Impeccably maintained 4 bedroom, 3.5 bath TILE ROOF home in the highly desired Eagle Creek community. Situated on a private lot with no rear neighbors; this home will not disappoint! You are greeted by a brick paver, covered porch with 8ft double entry doors. An open floor plan with volume ceilings and lots of natural sunlight. The formal living room, dining room, MASTER SUITE, powder room and great room are on the FIRST FLOOR. The second floor has 3 spacious guest bedrooms, 2 full baths, a MEDIA ROOM (risers included) PLUS a LOFT/BONUS area perfect for a workout space or pocket office! Wonderful MASTER SUITE with 2 walk-in closets, sliders leading to the outdoor patio and a master bath with a large garden tub, walk-in shower and double vanities. Many upgraded features including beautiful WOOD-LOOK PORCELAIN TILE (1st flr), granite counter tops in the kitchen and bathrooms, 5¼ base and crown molding (1st flr), surround speakers in the master, living room, patio and media room. Your outdoor oasis awaits with a brick paver, screened in patio overlooking a private and fenced backyard. Large laundry room with utility sink and Samsung front load washer and dryer are included. A 3 car garage completes it all! Eagle Creek is a guard gated golf course community and located in the heart of Lake Nona. Amenity rich with 3 community pools, tennis courts and basketball courts, clubhouse, fitness center and community activities. Truly a place to call home! ', 2010, 4, 4, 0, 2886, 6366, '8345 Prestbury Dr', '', 'Orlando', 16, '32832', '28.367786', '-81.2414022\r', 1508462783, 1508462783, 1794, 275, 8, 2),
  120. (279, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,601 sq ft.', 'Welcome to your immaculately maintained home! As you approach the house your enthusiasm will soar from the fantastic curb appeal provided by beautiful trees in the front yard. Then upon entering the house you will immediately be impressed by the spacious feeling provided by the perfectly laid out floor plan. The Open concept coupled with the presence of a separate additional dining room and living room makes this house one that is perfect for relaxing or entertaining. The kitchen is complete with gorgeous granite countertops. The master bedroom is large and is accompanied by a beautiful master bathroom and the other bedrooms are of nice size as well. Moving out back you will be enthralled by the serene environment that the pool and screened in Lanai offer making it a perfect place to grill out with friends or just relax by the pool. All of this is right in the heart of Dr. Phillips close to restaurant row, shopping, theme parks, and I-4 to give easy access to anywhere in the greater Orlando area. Book your opportunity to be impressed! ', 1989, 4, 3, 0, 2601, 12847, '9932 Sublette Ave #3', '', 'Orlando', 16, '32836', '28.4214833', '-81.4988659\r', 1508462785, 1508462785, 1819, 279, 1, 1),
  121. (285, 1, 1, 'Single Family Residential, 5 beds, 3.0 baths, 3,400 sq ft.', 'Quintessential Florida charm and stylish modern appeal blend expertly in this huge, 3,400 square foot home. Located in exclusive North Shore at Lake Hart, the home sits just steps away from great schools and amenities. The home boasts 3 full bathrooms and five bedrooms, one of which is downstairs – perfect for live-in relatives or guests. Upstairs, find 4 more spacious bedrooms PLUS a generous bonus loft. The home is very well-appointed – with ceramic tile floors, arched entries and elegant chair-rails. The kitchen is dazzling – with granite counter tops and backsplash, plus upgraded cabinetry. With its handy serving-bar and prep-island, you\'ll love entertaining guests or catching glimpses of the pool deck through triple-sliders while you cook. The second you set foot on the screen-enclosed pool patio, you\'ll be dreaming of BBQ parties and hot-tub relaxation. Back inside, the bedrooms are all sizeable. The master bath sets you in luxury – with double vanity, soaking tub and glass-enclosed shower. The home\'s garage is a rare find – big enough for 3 cars! Situated within short distance of Moss Park Elementary and fantastic North Shore Amenities (like fitness center, tennis, ballfields, parks and playgrounds) your family will find all they need in this picture-perfect community. Check out our full motion walk through video! ', 2005, 5, 3, 0, 3400, 8749, '9926 Mountain Lake Dr', '', 'Orlando', 16, '32832', '28.405007', '-81.2213066\r', 1508462789, 1508462789, 1860, 285, 1, 1),
  122. (286, 1, 16, 'Condo/Co-op, 1 beds, 1.0 baths, 754 sq ft.', 'MULTIPLE OFFERS-HIGHEST & BEST BY 5:00PM ON 10/18/17 Amazing Opportunity To Own This One Bedroom/One Bath Condo In Desirable Lexington Place Community In The Heart Of Orlando, Minutes To Sea World, Disney, Universal Studios. Community Features A Pool, Jacuzzi, Tennis Court, Fitness Room, Movie Room, Steam Room & Racquetball Indoor Court And Much More. ', 1989, 1, 1, 0, 754, 9021, '11582 Westwood Blvd #1414', '', 'Orlando', 16, '32821', '28.3961602', '-81.472839\r', 1508462790, 1508462790, 1869, 286, 54, 5),
  123. (290, 1, 16, 'Condo/Co-op, 1 beds, 1.0 baths, 836 sq ft.', 'TRADITIONAL SALE!! Beautiful unit with tile flooring. Centrally located condominium close to everything!! Minutes away from Orlando International Airport, restaurants, major expressways. Call us today to schedule a showing. Selling AS/IS with right to inspect. If exact square footage is a concern, the property should be independently measured. Buyer to independently verify all condo and HOA association info and fees ', 1990, 1, 1, 0, 836, 3696, '5448 E Michigan St #3', '', 'Orlando', 16, '32812', '28.5136802', '-81.3147804\r', 1508462792, 1508462792, 1893, 290, 8, 2),
  124. (293, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 2,000 sq ft.', 'Quality Remodel. New Kitchen with Granite C-tops, SS Appliances, Wood Tile Floors (not laminates) Throughout, Both Bathrooms are remodeled, Fresh Paint In/Out, 5 1/4\" Baseboards, Beautiful Slate Tile on the Front Porch, New Plush Carpeting in the Bedrooms, Updated Electrical Outlets, Lighting, Fans, Outside Box-GE. Large Family Room with Fireplace & Built in Desk. Large Covered porch and a Big Backyard. Oversized Laundry Room. THIS HOME HAS IT ALL!! SHOWS GREAT!! ', 1979, 4, 2, 0, 2000, 13217, '56 Wintergreen Way', '', 'Orlando', 16, '32825', '28.5439859', '-81.2626573\r', 1508462794, 1508462794, 1912, 293, 1, 1),
  125. (294, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 2,115 sq ft.', 'Fabulous 4 bedroom 2 bathroom home located in Mabel Bridge. Numerous upgrades throughout. Gourmet kitchen includes solid wood cabinets, stone counter tops, tile backsplash and stainless steel appliances. Meticulously maintained and cared for. Backyard is fenced and ideal for families and pets. Irrigation system sourced from reclaimed water providing savings to utility bill. Mabel Bridge features an expansive community pool, a chipping and putting green, playgrounds, and soccer field. Ideally located! Minutes away from area attractions, world class shopping, and Restaurant Row. Easy access to Orlando International Airport, I-4 and 429. ', 2013, 4, 2, 0, 2115, 6504, '11714 Verrazano Dr', '', 'Orlando', 16, '32836', '28.4374648', '-81.5544818\r', 1508462794, 1508462794, 1919, 294, 1, 1),
  126. (306, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 1,261 sq ft.', 'You\'ll fall in love with the breathtaking panoramic views of the city from the floor to ceiling windows in this gorgeous 2/2 in the heart of downtown. This unit is move in ready!! Kitchen features beautiful dark wood cabinets, granite counter tops, and stainless steel appliances. Unit comes with 2 assigned parking spots. Extremely secure, high tech security building offers owners finger print access to building and recreational facilities. Building features gorgeous rooftop pool with outdoor grilling space, fitness center and large community room equipped with sofas, TV, Kitchen, etc. , as well as full concierge service with 24 hour security. ', 2007, 2, 2, 0, 1261, 0, '155 S Court Ave #1601', '', 'Orlando', 16, '32801', '28.5409837', '-81.3777392\r', 1508462800, 1508462800, 1991, 306, 54, 5),
  127. (307, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,194 sq ft.', 'SHORT SALE. Sitting in the Enclave community of 48 homes this spacious 4 Bedroom 3 Bath Single family home has a large master, and master bath with dual vanities, a jacuzzi tub, separate shower and large closet. Built in 2007. ', 2007, 4, 3, 0, 2194, 10108, '7210 White Trillium Cir', '', 'Orlando', 16, '32818', '28.6066254', '-81.478133\r', 1508462801, 1508462801, 1993, 307, 1, 1),
  128. (309, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,415 sq ft.', 'Welcome to your new home! This beautiful ranch style home offers 3 bedrooms and 2 baths. When you first approach the home you will see the bright terracotta tile roof, which makes this home stand out in the neighborhood. As you enter the home, on your right you will find the spacious living room, enough to host a large gathering. To your left you are greeted by the formal dining room which is just steps away from the kitchen. New appliances have been installed just this month. Just a few steps away you will find another spacious living area which functions as the family room. On the other side of the home you will find the 2 smaller bedrooms located close to the guest bath, and further along the hallway is the master bedroom with its private bath. The large back yard, which is completely fenced, offers the privacy that you want. If you like planting this space is perfect for you; you will love the large avocado tree and lemon tree that’s back here. The home sits on a corner lot and it’s perfect for the growing family. Located close to Winter Park and only 2 minutes away from I4, it offers easy access to Downtown or the beaches. Don’t waste time; this home is a perfect candidate for the Orange County DPA. Contact us today. ', 1959, 3, 2, 0, 1415, 10232, '5333 Kingswood Dr', '', 'Orlando', 16, '32810', '28.6093799', '-81.398662\r', 1508462802, 1508462802, 2008, 309, 8, 2);
  129. INSERT INTO `listings` (`id`, `owner_id`, `property_type`, `title`, `description`, `yearbuilt`, `beds`, `baths`, `sleeps`, `sqfeet`, `lotsize`, `address1`, `address2`, `city`, `state`, `zipcode`, `latitude`, `longitude`, `created`, `updated`, `id`, `listing_id`, `facility_id`, `category_id`) VALUES
  130. (310, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,533 sq ft.', 'Beautiful one story home in gated Golf community in Lake Nona area. This home features a very efficient and practical floor plan with 4 bed/3 bath/2 car garage with an expanded driveway for 3 cars. Ceramic tile in all wet areas, kitchen, L/R, D/R, and family room. The bedrooms & office have elegant laminate flooring. The over-sized screened porch backs to conservation area, is perfect for relaxation, grilling, and family enjoyment. Crown molding through the formal living room, family room, kitchen and breakfast nook. Kitchen has 36\" cabinets w/ crown molding, corian counter-tops, and many other upgrades. This community has a pool, exercise room, playground; tennis, basketball and baseball courts. Location is prime, within minutes to major attraction, International airport, medical city, local shops, and rated A schools! ', 2006, 4, 3, 0, 2533, 9345, '10174 Mallard Landings Way', '', 'Orlando', 16, '32832', '28.395953', '-81.224771\r', 1508462803, 1508462803, 2020, 310, 54, 5),
  131. (312, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,432 sq ft.', 'This three bedroom home is located near Rosemont just off North Lane within minutes to shopping and schools. It includes a spacious floor plan with ceramic tile throughout, a big family room, nicely appointed kitchen with newer cabinets, renovated bathrooms, full size washer/dryer, patio for the BBQ, fenced yard and large 16x20 outside storage shed. ', 1975, 3, 2, 0, 1432, 8251, '4824 Stony Brook Ln', '', 'Orlando', 16, '32808', '28.5953381', '-81.4456549\r', 1508462804, 1508462804, 2028, 312, 1, 1),
  132. (316, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 3,034 sq ft.', 'Classic Florida Bungalow in beautiful Thornton Park -Property is steps away from shops, restaurants and Lake Eola. This beautifully remodeled home features formal living and dining rooms, a large kitchen with breakfast area, and a first floor office/den with an attached full bath. The second floor offers two bedrooms with an updated hall bath, and a lovely master suite with a large bath complete with two sinks, a large shower and spacious master closet. Outside enjoy a front porch and private back deck. In addition to the main house this property offers a spacious guest house with one bedroom, one bath, office/den, living/dining and a full kitchen - a perfect rental property. ', 1920, 4, 3, 0, 3034, 7055, '116 N Thornton Ave', '', 'Orlando', 16, '32801', '28.5443714', '-81.3652061\r', 1508462806, 1508462806, 2055, 316, 8, 2),
  133. (324, 1, 1, 'Single Family Residential, 5 beds, 3.5 baths, 2,807 sq ft.', 'Bishop Landing is in the perfect location! Only minutes from Medical City, 5 minutes from the turnpike, not even 10 minutes from the airport, 20 minutes from Disney, and only 40 minutes from the beach! Bishop Landing is at the center of all but conveniently tucked away from all the commotion! 10 great floor plans for you to choose from. Express has never looked so good! * * Please note that no representations or warranties are made regarding school districts or school assignments; you should conduct your own investigation regarding current and future schools and school boundaries. ', 2017, 5, 4, 0, 2807, 6900, '14049 Phifer Ln', '', 'Orlando', 16, '32824', '28.428787231445', '-81.36491394043\r', 1508462810, 1508462810, 2102, 324, 11, 2),
  134. (325, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,691 sq ft.', 'Freshly painted, beautifully landscaped home with new carpet, large screened patio and large open patio overlooking generous ponfront rear yard. Convenient to University of Central Florida, Full Sail University, Rollins College and Valencia Community College as well as downtown Winter Park, Altamonte Springs, Oviedo, and Winter Springs. Great open floor plan with vaulted ceilings. You will KICK yourself if you miss out on this amazing home! ', 1995, 3, 2, 0, 1691, 43246, '3274 Lake Twylo Rd', '', 'Orlando', 16, '32817', '28.594064', '-81.2328979\r', 1508462811, 1508462811, 2112, 325, 1, 1),
  135. (328, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,291 sq ft.', 'Location!!!! This is a well maintained pool home with a fenced back yard. NO HOA. A must see!!!. Beautiful home in an established neighborhood. Spacious Florida Room with climate control! Great for entertaining! Beautiful inviting in ground pool with open patio. Newly remodeled kitchen, baths and flooring conveniently located near major highways, shopping malls, Hospitals and close to the Orlando Int’l Airport. Great potential. Could be your dream home. ', 1980, 3, 2, 0, 1291, 7472, '7516 Autumn Pines Dr', '', 'Orlando', 16, '32822', '28.5297432', '-81.2844946\r', 1508462813, 1508462813, 2132, 328, 54, 5),
  136. (331, 1, 1, 'Single Family Residential, 5 beds, 4.0 baths, 3,399 sq ft.', 'A Place With Lots of Space, A full family will fit nicely into this 2-story stucco home with Tile roof built by MI Homes in Ziani in Lake Nona. Has 5 bedrooms, 4 bathrooms, 3 Car Garage, tasteful dining room, elegant living room with carpeting, master suite with linen closet, walk-in closet, two-person shower , whirlpool tub , dual sinks, , welcoming family room, family-friendly kitchen with dishwasher, microwave, electric range, custom cabinets, pantry, breakfast area, Inside laundry room , Split plan , cathedral ceiling, office room . 2nd floor has a separate room and bathroom with extra room which can be play or media room and large storage room. Cozy screen porch with a beautiful water view, Interior has New Paint , Gated Community with Playground. ', 2005, 5, 4, 0, 3399, 11605, '9986 Oak Quarry Dr', '', 'Orlando', 16, '32832', '28.4319206', '-81.2506187\r', 1508462814, 1508462814, 2146, 331, 11, 2),
  137. (332, 1, 1, 'Single Family Residential, 5 beds, 4.0 baths, 3,611 sq ft.', 'Welcome home to your lavish SW Orlando home. Pride of ownership shows in every detail. Large open kitchen with island and extended cabinets and granite counter tops. Stainless steel appliances and wine refrigerator accent the white cabinets. Double seamless pocket doors bring the spacious screened lanai and green backyard into this home. View fireworks nightly with your family and guests right from your front door or back yard. Master retreat will spoil you with large walk in shower and double vanity sinks. There is also a guest suite on the first floor and three more bedrooms and a media room on the second floor. Plenty of storage and loaded with extra options. Close walk or bicycle ride to Lakeside Village! ', 2015, 5, 4, 0, 3611, 9017, '9430 Royal Estates Blvd', '', 'Orlando', 16, '32836', '28.4333248', '-81.5593839\r', 1508462815, 1508462815, 2149, 332, 8, 2),
  138. (338, 1, 1, 'Single Family Residential, 3 beds, 1.0 baths, 1,368 sq ft.', 'Property in move in condition. Freshly painted inside out. Kitchen granite counter top. Appliances Included. Laminated flooring all over the house, tile floor in the bathroom. Patio shed recently upgraded. Fenced house located near restaurants, Florida & Millenia\'s malls. Easy to show. ', 1993, 3, 1, 0, 1368, 9980, '5798 Tomoka Dr', '', 'Orlando', 16, '32839', '28.4750732', '-81.3946829\r', 1508462818, 1508462818, 2190, 338, 1, 1),
  139. (339, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,944 sq ft.', 'Under Construction. Located less than a mile from Medical City inside the beautiful neighborhood of Laureate Park. This home offers 3 Bedrooms, 2 baths, and a 2 car garage. Open Floor Plan with the an Enclosed Study, Kitchen has beautiful 42\" cabinets, granite counter tops and GE Stainless Steel Appliances. This one story floor plan is a MUST SEE! Seller to pay $5,000 towards Closing Costs using Preferred Lender and Title Company. Feel confident buying your next home from the largest privately-held home builder in America because of our 40-year reputation for delivering quality new homes, customer satisfaction and warranty service. ', 2017, 3, 2, 0, 1944, 5399, '9254 Yonath St', '', 'Orlando', 16, '32827', '28.369807', '-81.250162\r', 1508462819, 1508462819, 2197, 339, 8, 2),
  140. (341, 1, 40, 'Townhouse, 3 beds, 2.5 baths, 1,626 sq ft.', 'Nona Terrace is a gated townhouse community located near nature preserves and ponds in Lake Nona. This home is a must see and requires little maintenance. It is located on lot with a backyard that faces a serene preserve view. It has an open floor plan and luxury kitchen kitchen complete with granite countertops. Amenities include community pools, cabanas and a clubhouse. ', 2013, 3, 3, 0, 1626, 2200, '10640 Savannah Plantation Ct', '', 'Orlando', 16, '32832', '28.413925', '-81.234635\r', 1508462820, 1508462820, 2213, 341, 54, 5),
  141. (347, 1, 40, 'Townhouse, 3 beds, 2.5 baths, 1,626 sq ft.', 'Nona Terrace is a gated townhouse community located near nature preserves and ponds in Lake Nona. This home is a must see and requires little maintenance. It is located on lot with a backyard that faces a serene preserve view. It has an open floor plan and luxury kitchen kitchen complete with granite countertops. Amenities include community pools, cabanas and a clubhouse. ', 2013, 3, 3, 0, 1626, 2200, '10644 Savannah Plantation Ct', '', 'Orlando', 16, '32832', '28.4139592', '-81.2345756\r', 1508462824, 1508462824, 2246, 347, 8, 2),
  142. (351, 1, 1, 'Single Family Residential, 3 beds, 2.5 baths, 1,144 sq ft.', 'Don\'t miss this Darling and Tastefully remodeled Bungalow on a Tree Lined Street. .. .Walk into a warm living room with charming rounded doorways, which opens up to a recently remodeled kitchen boasting St. Cecelia Granite counter tops, custom cabinetry and ceramic tile flooring. All appliances, refrigerator and washer and dryer will stay in the home for the new owner to enjoy! Separate laundry room inside the home for your convenience. Three ample sized bedrooms with good storage, including a lovely Master Suite! Don\'t forget to see a ton of secure parking, or RV/Boat parking on the side and back of the home. Don\'t miss this lovely home. .. get in before the new Stadium is built! ', 1923, 3, 3, 0, 1144, 4830, '625 W 105th St', '', 'Los Angeles', 11, '90044', '33.9409411', '-118.2857884\r', 1508462827, 1508462827, 2283, 351, 54, 5),
  143. (357, 1, 1, 'Single Family Residential, 5 beds, 4.0 baths, 3,578 sq ft.', 'Incredibly rare, Studio City hills, SINGLE STORY pool home, perfectly placed on a large flat lot with PANORAMIC VIEWS! Located in the famed “Dona”streets, this Laurelwood West development, five bedroom, four bath, nearly 3600 square foot home is highlighted by an entertainers’ back yard, a magnificent indoor/outdoor flow, privacy, elegance and unobstructed views. Fantastic mid-century floorplan features a large open concept living/dining area that brings the highly sought after California lifestyle to reality. Huge single step down family room. Four bedrooms on one side of the home, including the grand master bedroom retreat, complete with spacious walk in closet and bath, and leads to both back and side yards. The fifth bedroom is located in its own wing, and is ideal for guests, in-laws, or as an office/playroom. Other features include a cooks’ kitchen, breakfast area, laundry room, direct access garage and tons of closet space and storage throughout. New roof installed in 2015. Central location with easy access to the Westside, Beverly Hills and the San Fernando Valley, plus some of the area’s best hiking and trails nearby. Located in the award winning Carpenter school district (subject to availability). This pride of ownership home has been well maintained over the years. Move right in, or let the blank canvas inspire, and tailor to your perfection. Don’t miss this amazing opportunity! ', 1961, 5, 4, 0, 3578, 11502, '11363 Dona Teresa Dr', '', 'Studio City', 11, '91604', '34.1295624', '-118.3809051\r', 1508462829, 1508462829, 2311, 357, 54, 5),
  144. (359, 1, 1, 'Single Family Residential, 1 beds, 1.0 baths, 576 sq ft.', 'Affordable, cute little home located in a quiet community near the foothills in Tujunga. This is a great alternative to a condo. This home features an open floor plan, remodeled bath with large walk in shower, bright and sunny w/ lots of windows that provide plenty of natural light, original hardwood floors, full copper plumbing, stove washer & dryer included, covered porch, carport for 1 car, shade trees, pride of ownership. Come see this home, it won\'t last. ', 1950, 1, 1, 0, 576, 1523, '10039 France Ave', '', 'Tujunga', 11, '91042', '34.2508241', '-118.2784084\r', 1508462830, 1508462830, 2316, 359, 8, 2),
  145. (362, 1, 1, 'Single Family Residential, 3 beds, 4.0 baths, 3,855 sq ft.', 'Unique opportunity, newer built & luxurious 2-story home. Tucked away in serene area with valley views. Drought tolerant landscaping & custom stone walkway add to curb appeal. High ceilings & French doors throughout. Living, family, & dining rooms. Elegant double-sided fireplace. Open & upgraded kitchen with granite counters, center island/breakfast bar, newer range, dishwasher, eating area, & walk-in pantry. Convenient guest bath. Laundry room. Multiple balconies upstairs overlook backyard. Spacious master suite boasts fireplace, walk-in closet, & private bath featuring impressive shower w/ dual shower heads & separate spa tub. Second master suite at other side also has private bath w/ shower & separate spa tub. Third bedroom w/ 2 closets. Hall bath w/ shower. Additional features include upgraded baths, tile, wood, & carpet flooring, dual A/C, fresh interior paint, recessed lights, & newer water heater. Direct access to oversized 2-car garage w/ storage space. Long driveway for possible RV parking. Nature surrounds you in the backyard. Open space & mountain views. Private road with newer custom-built million dollar properties in the neighborhood. Enjoy the away from city feeling, yet close to freeway access. Must see! ', 2007, 3, 4, 0, 3855, 11000, '7854 Mesa Dr', '', 'Simi Valley', 11, '93063', '34.257751273', '-118.6336067\r', 1508462832, 1508462832, 2336, 362, 8, 2),
  146. (363, 1, 1, 'Single Family Residential, 3 beds, 2.75 baths, 1,726 sq ft.', 'An exceptional modern home in highly desirable Silicon Beach neighborhood. Recently remodeled, this home impresses from the moment you step inside. The living area offers a fantastic open floor plan with vaulted ceiling, white wide oak plank hardwood flooring, and a wood burning fireplace with tile back splash. A delightful modern kitchen features butcher block countertop, induction cooktop, convection oven, and built in dishwasher. Romantic master bedroom with open bathroom concept. This home is well equipped with energy efficient heating and cooling, double pane vinyl windows, low water consumption and LED lighting throughout. Entertain your guests with the great outdoor living space with large redwood patio, redwood seating area with firepit and outdoor shower. Close to chic restaurants, upscale boutiques, art galleries and the beach. ', 1912, 3, 3, 0, 1726, 4234, '241 7th Ave', '', 'Venice', 11, '90291', '34.0008261', '-118.4705214\r', 1508462833, 1508462833, 2351, 363, 54, 5),
  147. (366, 1, 1, 'Single Family Residential, 3 beds, 4.0 baths, 2,194 sq ft.', 'This fabulous home in the Hollywood Hills is located in a private, gated community with modern architecture w/ the best views of the Hollywood Hills. This home boasts an open floor plan with a modern appeal, it features a state of the art kitchen equipped with an over sized island, custom cabinetry, elegant counter-top & stainless steel energy efficient appliances, The elaborate baths include luxury counter-tops. environmentally friendly fixtures throughout entire bath & home. energy efficient lighting, recess lighting throughout, plenty of natural light, 24 hr secure gate, 2 car attached garage, tri-level, Master bedroom, balcony with views, tank-less water heater, insulated air ducts, & new electrical, This home is well situated with convenient access to the Hollywood bowl, Runyon canyon, Universal Studios, & Hollywood. ', 2015, 3, 4, 0, 2194, 2806, '2776 Wright Ln', '', 'Los Angeles', 11, '90068', '34.119496', '-118.33984\r', 1508462834, 1508462834, 2365, 366, 8, 2),
  148. (372, 1, 1, 'Single Family Residential, 3 beds, 3.0 baths, 1,700 sq ft.', 'BACK ON THE MARKET and super easy to show - Charming pool home on a fantastic street in Valley Glen. Great pocket, just north of Victory. Gated for privacy. Large lot with endless possibilities. Main house features 3 bedrooms and 2 baths plus a detached guest unit (converted garage) with its permitted full bathroom. Approximately 1700 square feet combined. Original hardwood floors throughout most of the home, two fireplaces and a huge master bedroom suite! Formal living and dining areas with stunning original coves and arches - loaded with character. All three bedrooms off the main hallway. Two generous sized complementary bedrooms share a full bath - leading to the master suite, featuring it\'s own den/bonus area, fireplace, and french doors that open to the wonderful backyard, highlighted by an inviting pool, grassy back yard plus plenty of room to entertain. Updates include: central HVAC, copper plumbing and updated electrical. Long extended driveway perfect for multiple vehicles/RV/etc. This is an amazing opportunity, don\'t miss your chance! ', 1941, 3, 3, 0, 1700, 7911, '14012 Gilmore St', '', 'Valley Glen', 11, '91401', '34.187317', '-118.438278\r', 1508462838, 1508462838, 2411, 372, 1, 1),
  149. (373, 1, 40, 'Townhouse, 4 beds, 3.0 baths, 2,046 sq ft.', 'Have you been looking for a newer, spacious stand alone Town Home that boasts privacy behind the security gates of the lovely Harbor Highlands Development in San Pedro. .. .search no more! This well kept complex is only a few years old, has a glistening pool and lovely grounds to walk through. The home is towards the back of the complex and has no neighbors behind it. .. super private! When you walk up to the front door, you\'re met with lush and green landscaping up to this Spanish Stunner! As you enter, the rich dark wood floors really stand out, coupled with an open kitchen, dining and living room, perfect for entertaining or just having family time! The kitchen boasts deep espresso cabinetry, granite counter tops and Stainless Appliances! From the living room, you are led out to an oasis of a back yard! With it\'s shaded canopy, you can truly bring the back yard into your living space! Don\'t miss the Master Suite with bonus room attached. .. it\'s a resort style getaway for mom and dad! Laundry room is conveniently situated upstairs and has plenty of storage and folding space. All bedrooms are upstairs in this Traditional floor plan beauty. .. . Clean white bathrooms, Air Conditioning and modern ceiling fans and touches throughout this home. .. MUST SEE! ', 2014, 4, 3, 0, 2046, 18086, '783 Gatun St #231', '', 'San Pedro', 11, '90731', '33.757643', '-118.2945505\r', 1508462839, 1508462839, 2421, 373, 54, 5),
  150. (378, 1, 1, 'Single Family Residential, 3 beds, 3.5 baths, 2,194 sq ft.', 'Built in 2016, this modern architectural home is in Lennar, the new trendiest gated community in Hollywood Hills. Top floor offers an expansive, bright open floor plan perfect for entertaining with wide-plank wood flooring throughout. Gourmet kitchen with custom Island, thermofoil cabinetry, caesarstone countertops with full backsplash, extra deep stainless steel farmers sink, high-end GE stainless steel appliances including a French door refrigerator and recessed lighting throughout. 2nd floor has a private bedroom and bathroom with triple door closest. Downstairs, you\'ll find 2 bedrooms including the master suite that is equipped with relaxing spa-like bathroom, walk-in closet and a patio. Comes complete with green features including pre-wire electric car charger, dedicated area and conduit run for solar, LED lighting throughout most of the home, low-e double pane windows and central air and heat. Two car attached garage with stylish glass garage doors. Close to Hollywood bowl & Sunset blvd. ', 2016, 3, 4, 0, 2194, 2981, '2780 Wright Ln', '', 'Los Angeles', 11, '90068', '34.119677', '-118.339977\r', 1508462842, 1508462842, 2445, 378, 1, 1),
  151. (388, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,542 sq ft.', '3 Bedroom 2 Bathroom Mid century gem located in the Arroyo View Estates neighborhood of Highland Park. This 1542 sqaure foot home sits on just under a 12,000 square foot lot. The spacious living room features vaulted ceilings and a beautiful floor to ceiling brick fireplace. The living room opens up to both the dining room and backyard. New laminate flooring adorns the main living areas and the entire interior has been freshly painted. The bedrooms feature new carpet and lots of natural light adding to the spacious feel of the home. New quartz countertops sit atop abundant cabinet space in the kitchen alongside brand new stainless steel appliances and a contemporary subway tile backsplash. The bathrooms feature fresh tile flooring and brand new vanities. Laundry hookups inside the two car garage. Entertain the whole family this holiday season in the abundant indoor and outdoor living spaces this corner lot has to offer. Conveniently located just blocks away from local parks, restaurants, and shops, this home truly is a gem. ', 1960, 3, 2, 0, 1542, 11894, '904 N Avenue 66', '', 'Highland Park', 11, '90042', '34.121548', '-118.17235\r', 1508462847, 1508462847, 2520, 388, 8, 2),
  152. (398, 1, 1, 'Single Family Residential, 6 beds, 10.0 baths, 8,458 sq ft.', 'A remarkable modernist compound. With breathtaking views & superstar privacy. This home to celebrities is located on the Historic Mulholland dr. With a star-studded list of Hollywood elite neighbors. Only minutes from Hollywood, Beverly Hills, universal, the Sunset strip and more. The property will amaze you with it\'s enormous amount of possibilities for entertaining, relaxing, dining in one of its many stunning areas. From it\'s glorious master suite, it\'s jaw-dropping media room, to its magical pool terracing down to overlook all of Hollywood. The house has all you could ever ask for and more with 3 kitchens, 2 large Lawns, spa and sauna, dream worthy spiral staircase, Aqueduct waterfalls features, and 3 car garage with direct access into the house ', 2003, 6, 10, 0, 8458, 18981, '7571 Mulholland Dr', '', 'Los Angeles', 11, '90046', '34.1273197', '-118.3600461\r', 1508462852, 1508462852, 2587, 398, 54, 5),
  153. (407, 1, 1, 'Single Family Residential, 6 beds, 3.0 baths, 2,568 sq ft.', 'LARGE FAMILY HOME - Buyers with Large family will love this property and create lasting memories. 3 bedrooms downstairs and 3 bedrooms upstairs, plus 3 full bathrooms. Most rooms are large and roomy, the upstairs bath has his and hers sinks and a back patio overlooking the city lights. Kitchen is brightened with granite counter-tops, maple wood cabinets. Living room has gas and wood burning fireplace. Mahogany finished wood is installed in living room ceiling adding character to this custom home. Close to everything, ', 1925, 6, 3, 0, 2568, 3553, '1906 West 66th St', '', 'Los Angeles (City)', 11, '90047', '33.9789298', '-118.3115582\r', 1508462857, 1508462857, 2648, 407, 8, 2),
  154. (408, 1, 16, 'Condo/Co-op, 2 beds, 1.5 baths, 1,080 sq ft.', '2 bedroom, 1.5 bath condominium built in 2003. Unit is in good condition and featuring 180 degree views from the large balcony. Wonderful kitchen area with granite counters, in unit laundry, tastefully designed bathrooms and so much more. This is a top floor end unit with an excellent floor plan and generous room sizes. In addition to being light and bright this unit features a center hall plan, recessed lighting, fireplace in living room, kitchen with granite countertops, central air and heat, and private storage room adjacent to parking. Don\'t curb appraise this delightful unit. Excellent location off of the 110 fwy. Great urban living only minutes North from Downtown LA and near shopping, dining and entertainment in nearby Pasadena. ', 2003, 2, 2, 0, 1080, 7501, '711 Bridewell St #4', '', 'Los Angeles (City)', 11, '90042', '34.1166295', '-118.1712874\r', 1508462858, 1508462858, 2655, 408, 8, 2),
  155. (419, 1, 29, 'Multi-Family (2-4 Unit), 6 beds, 2.0 baths, 2,640 sq ft.', 'Wonderful Spanish character duplex with bonus permitted living space. Built in 1925 the property has two 3 BD, 1.50 BA and is town house style. There is a river running through it. Also done with permits is a studio living space with loft bed overlooking the brook. Two addresses are attached to this very unique property in historic Longwood Highlands. ', 1925, 6, 2, 0, 2640, 8121, '1037 South Longwood Ave', '', 'Los Angeles (City)', 11, '90019', '34.0559696', '-118.3389856\r', 1508462864, 1508462864, 2740, 419, 54, 5),
  156. (421, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,291 sq ft.', '15843 San Fernando Mission Blvd, Granada Hills, CA 91344 is a single family home built in 1956. ', 1956, 3, 2, 0, 1291, 7199, '15843 San Fernando Mission Blvd Unit B', '', 'Granada Hills', 11, '91344', '34.2721237', '-118.477591\r', 1508462866, 1508462866, 2751, 421, 54, 5),
  157. (423, 1, 1, 'Single Family Residential, 3 beds, 3.0 baths, 2,952 sq ft.', 'Perched on one of the most desired streets in Los Feliz, sits this designer home with accents of a rustic farmhouse that meets today\'s modern sophistication. Completely remodeled this loft floor plan opens up all common areas from the living room to the kitchen with views overlooking the surrounding yards. The gourmet kitchen is equipped with custom cabinets, white Carrara marble countertops and Thermador stainless steel appliances. The master suite overlooks the backyard with floor to ceiling glass walls and custom sliding barn doors directly from the farmlands of Utah, USA. Other features include glass wine room at the entry, French white oak floors and German made bathroom cabinets. The large side and front grassy yard with rolling hills, tiered back yard with room for a pool and covered patio with Italian porcelain tiles. Just steps from the Greek Theatre and near to some of Los Angeles best landmark restaurants and shopping there will be no other place you will want to live. ', 1952, 3, 3, 0, 2952, 12980, '2400 Glendower Ave', '', 'Los Angeles (City)', 11, '90027', '34.1134262', '-118.2916536\r', 1508462866, 1508462866, 2758, 423, 8, 2),
  158. (426, 1, 40, 'Townhouse, 3 beds, 3.0 baths, 1,752 sq ft.', 'Beautiful 2 story 3 bedroom 1700+ sq ft top floor corner condo with huge private roof top patio and beautiful mountain views. Vaulted ceiling, fireplace in the living room, balconies in each room, washer and dryer inside the unit. Secured building, 2 parking spots side by side, pool, close to everything and near a public park with tennis courts. ', 1982, 3, 3, 0, 1752, 19176, '7515 Winnetka Ave #302', '', 'Winnetka', 11, '91306', '34.2068129', '-118.571311\r', 1508462869, 1508462869, 2783, 426, 54, 5),
  159. (439, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,174 sq ft.', 'Nice house in a quiet cul-de sac. ', 1956, 3, 2, 0, 1174, 6278, '12851 De Haven Ave', '', 'Sylmar', 11, '91342', '34.3035889', '-118.4466644\r', 1508462876, 1508462876, 2851, 439, 1, 1),
  160. (445, 1, 1, 'Single Family Residential, 3 beds, 3.0 baths, 1,842 sq ft.', 'Masterful design and modern luxury are uniquely embodied in this meticulously maintained home. Crafted to perfection, the open floor plan encompasses 3 bedrooms and 3 bathrooms. Step inside and you are instantly greeted by the cozy living room complete with hardwood floors, an elegant bar area and dual sliding glass doors leading to the backyard. The living room conveniently opens to the dining area perfect for intimate family gatherings. No detail was left untouched with this exquisite, modern style kitchen. Complete with recessed lighting, a dual basin sink, gorgeous tiled backsplash, white cabinets with designer trim and a cozy breakfast area highlighted by pendant lighting this kitchen will inspire your inner Chef. Retreat for the evening to the Master Suite boasting dark laminate wood floors. Enjoy your morning coffee on the expansive balcony overlooking the breathtaking mountain views. The two additional bedrooms located on the 2nd level are efficiently laid out and filled with an abundance of natural light. Escape from the modern world to your own private backyard oasis. Relax under the covered patio by the outdoor fireplace complimented by mosaic tiles. The tranquil fountain, lush greenery and stone path walkway complete the serene ambiance. Nestled in the highly desirable Mountain Glen gated community, this is an opportunity you do not want to miss! ', 2002, 3, 3, 0, 1842, 3588990, '13248 Alta Vista Way', '', 'Sylmar', 11, '91342', '34.3115167', '-118.403288\r', 1508462879, 1508462879, 2903, 445, 54, 5),
  161. (451, 1, 1, 'Single Family Residential, 6 beds, 5.0 baths, 7,400 sq ft.', 'Immaculate Woodland Hills estate is waiting for you! Located at the end of a quiet cul-de-sac, this private, 7400 square foot. , custom-built ranch home includes a guest house, and sits on over an acre of beautifully landscaped grounds. Built in 1991, this fully-fenced home has it all, and you will enjoy the serene, park-like setting. The front of the property has fruit trees, while the rest of the property is surrounded by tall, mature redwood trees, and a lush green lawn! As you enter the home, you will find the entry warm and inviting to you and your guests. You will experience a breathtaking view of the expansive grassy backyard, into the enormous resort-like pool, and waterfall! The spacious, light-filled living room features a white lacquered paneled wall, and a large picture window to enjoy amazing views from. Deep-green marble fireplace has a gas start and is set up for burning wood. Ideal for visiting, reading or relaxing. Come and see this amazing estate today. Welcome home. ', 1991, 6, 5, 0, 7400, 50607, '23341 Ostronic Dr', '', 'Woodland Hills', 11, '91367', '34.1627451', '-118.6359155\r', 1508462882, 1508462882, 2942, 451, 54, 5),
  162. (455, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,264 sq ft.', 'Spectacular location for this Upgraded 3 Bedroom 2 Bath, Granada Hills Home. Approx 1260 sq ft featuring Fresh Paint, New carpet (over original hard wood floors) in Living Room, Hall and Bedrooms. Home also features Indoor Laundry, Professionally landscaped yards w/ private in-ground Spa and Block Wall Fencing. Home is Light and Bright w/ Open Floor Plan, Large Living Room and Screened in Patio. Spacious Country style Eat-in Kitchen, w/ new gas range/oven, tile counter tops and ceiling fan w/ lights. Bedrooms feature new 2\'\' blinds, lots of windows, Ceiling fans w/ lights and large closets. Spectacular yard w/ automatic sprinklers front and rear, extra wide concrete drive way, roll-up garage door. Home has been loved and is ready for a fast Escrow ', 1954, 3, 2, 0, 1264, 7500, '16009 Celtic St', '', 'Granada Hills', 11, '91344', '34.269351', '-118.480598\r', 1508462884, 1508462884, 2964, 455, 8, 2),
  163. (461, 1, 1, 'Single Family Residential, 2 beds, 1.0 baths, 1,092 sq ft.', 'Welcome buyers and investors. This 2 bedroom 1 bath is priced to sell. Great and excellent area of Los Angeles. Has lots of investor potential. Close to everything too much to mention. BETTER HURRY !!!!!!! ', 1926, 2, 1, 0, 1092, 4806, '2623 S Cloverdale Ave', '', 'Los Angeles', 11, '90016', '34.031813', '-118.3579345\r', 1508462888, 1508462888, 2994, 461, 8, 2),
  164. (466, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 994 sq ft.', 'Property is located in a quiet neighborhood in Eagle Park area. Roof was replaced within 6 years and A/C was replaced within 2 years. Tank less water heater. There is about 300SQF basement is not included in the total living area SQF. There are fruit trees, and garden area. Buyers to verify square footage, and permits with city. ', 1950, 3, 2, 0, 994, 2929, '1510 Donaldson St', '', 'Los Angeles', 11, '90026', '34.0903142', '-118.2469685\r', 1508462891, 1508462891, 3029, 466, 1, 1),
  165. (467, 1, 29, 'Multi-Family (2-4 Unit), 6 beds, 4.0 baths, 4,005 sq ft.', 'This one of a kind beauty is located in the Historic Garvanza area of Highland Park. This modern multi-unit Craftsman and Bungalow compound have a modern farmhouse feel. All three homes feature contemporary open floor plans with a traditional charm you will fall in love with. The luxury updates throughout include Carrera marble and white quartz countertops, open kitchen shelving, designer lighting and wide plank French Oak hardwood floors. The main home on Ave. 66 was built as a home in 1916 and has 2,120 sqft of living space with 3 bedrooms, 3.5 bathrooms and a den. The front bungalow on Crescent built in 1921 is 1,055 sqft with 2 bedrooms, 1.5 bathrooms, and a den. The rear bungalow is a newly constructed 1 bedroom and 1 bathroom. The grounds are beautifully landscaped with greenery between the units adding privacy throughout. The advantage of VACANT units in rent-controlled Los Angeles is a great investment in this trendy area. ', 1916, 6, 4, 0, 4005, 11009, '405 North Avenue 66', '', 'Los Angeles (City)', 11, '90042', '34.1166818', '-118.1776341\r', 1508462891, 1508462891, 3039, 467, 8, 2),
  166. (474, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 1,076 sq ft.', 'Don\'t miss your opportunity to own in this highly desirable West LA neighborhood. This wonderful condo showcases a spacious floorplan with 2 master suites at opposite ends, each with their own private hallway, walk-in closet, and full bathroom. The quiet unit features a washer/dryer inside the unit (along with a community laundry room if needed), an open kitchen, a large living room with gas fireplace, an outdoor patio, and central heat/AC. This delightful complex is immaculately maintained inside and out, and is located on a gorgeous tree-lined street of West LA. The building offers a secured entry, private fitness room, tandem parking spaces in an underground gated garage, ample guest parking spaces, as well as earthquake insurance and basic cable included in HOA dues. Conveniently located close to shopping, restaurants, caf~s, parks, and the Expo Line which gives easy access to all the Westside has to offer. ', 1989, 2, 2, 0, 1076, 35555, '1731 Barry Ave #119', '', 'Los Angeles (City)', 11, '90025', '34.0410387', '-118.452778\r', 1508462895, 1508462895, 3088, 474, 54, 5),
  167. (478, 1, 16, 'Condo/Co-op, 3 beds, 2.0 baths, 1,168 sq ft.', 'This 3 bedroom condo is rarely seen on the market and with 2 patios in a highly desirable quiet location at rear corner of the complex. Ceilings have just been smoothed out with fresh paint. Spacious living room with with fireplace and lots of sunlight , balcony that permits you to see your guest entering and open the gate from your patio. All 3 bedrooms have been upgraded with new wood like flooring, fresh paint, ceilings smoothed throughout, inside laundry with washer and dryer included. Convenient indoor laundry area. Central air & heat. Sparkling community pool and lighted tennis courts. Gated with private car garage with additional storage. Conveniently located close to The Village at Westfield, Warner Center, shopping, dining, theatres, freeway access and mass transportation. ', 1981, 3, 2, 0, 1168, 119919, '7800 Topanga Canyon Blvd #211', '', 'Canoga Park', 11, '91304', '34.21114', '-118.605174\r', 1508462897, 1508462897, 3108, 478, 8, 2),
  168. (483, 1, 1, 'Single Family Residential, 4 beds, 2.75 baths, 3,492 sq ft.', 'Beautiful Sanctuary in the hills of Studio City. Three bedrooms, three baths and a convertible den in the main house plus a stunning guest studio with a separate entrance. The heart of the home is a spacious flow-through family room-dining area-kitchen. Recently refinished wood floors contrast wonderfully with white coffered ceilings, wainscoting and brickwork. The living room features a wall of windows, fireplace, and large Bay window. Step up to a sitting room hosting French doors to the gardens. The master suite, entered through a charming barn-style sliding wood door, provides a relaxing light-filled retreat. Its sitting room/office opens via French doors to a private balcony. The grounds are truly enchanting. Brick patios offer intimate spaces for al fresco dining. Terra cotta tile surrounds a sparkling pool, and an inviting separate guest studio above a detached two-car garage featuring a kitchenette, bath and patio shaded by mature trees. Carpenter Community Charter School District. ', 1950, 4, 3, 0, 3492, 15808, '3724 Buena Park Dr', '', 'Studio City', 11, '91604', '34.1389671', '-118.3881253\r', 1508462900, 1508462900, 3138, 483, 1, 1),
  169. (484, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,736 sq ft.', 'Fabulous Opportunity! Move in or update this huge 4 bedroom 2 bath home. This single story over sized fenced in yard sits on a corner lot. Home has been freshly painted inside and new flooring throughout. Ac around 5 years old and new roof around 2 years ago. Two car garage/workshop. So many possibilities. Home has been vacant for two years. Assessors shows 4 bedrooms currently being used as 3 bedrooms (see agent remarks). Agents please see agent remarks before writing. ', 1955, 4, 2, 0, 1736, 7929, '16526 Index St', '', 'Granada Hills', 11, '91344', '34.2753028', '-118.4921408\r', 1508462900, 1508462900, 3143, 484, 8, 2),
  170. (486, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,337 sq ft.', 'Gorgeous remodeled 4 bedroom & 3 bathroom Mar Vista home. Formal living room looks out to the quiet tree-lined street and connects to the Great Room at the back thru a large open hallway that flows out to the back deck and grass backyard. The Great Room has a gourmet kitchen with custom cabinets, quartz counters, stainless steel appliances and peninsula for counter dining. The dining space open to the family room with vaulted ceiling and to the deck thru collapsible glass doors for indoor/outdoor living. Amazing master suite with huge walk-in closet, beautiful master bathroom with oversized tiled shower and master sitting area that would make a nice office or in-room nursery. 2nd master suite has its own walk-in closet and marble tiled shower. The home feels new with new roof, new windows, new wood doors, new central air & heat, new beautiful hardwood floors and updated plumbing & electric. Quiet neighborhood near all the shops, restaurants & Trader Joes! ', 1939, 4, 3, 0, 2337, 6189, '3532 Greenfield Ave', '', 'Los Angeles (City)', 11, '90034', '34.0204257', '-118.4174059\r', 1508462901, 1508462901, 3159, 486, 8, 2),
  171. (488, 1, 1, 'Single Family Residential, 3 beds, 2.5 baths, 1,694 sq ft.', 'No Expense Spared on this Entertainer’s Home in Encino! Gorgeously remodeled offering an open floor plan with large kitchen, living room with fireplace, bar and dining area overlooking the covered patio and pool. Open kitchen with large island, shaker cabinets with soft closing hinges, quartz counter tops, stainless steel appliances, and pantry. Large living room with beautifully tiled fireplace and adjacent dining space. Sitting area off entry with built in bar. Half bath off kitchen perfect for guests. Two good size bedrooms share hall bath with dual vanity with quartz counters and backsplash, stunning shower with new tub and glass panel. Master bedroom with dual closets, slider to backyard, and it’s own bathroom offering walk in shower and dual vanity. Entertainers backyard offers covered patio with cable hook ups, custom privacy fencing, new pool decking, and pool with new tile and multi colored lighting. Upgrades include new HVAC system, Roof, lighting, flooring, Milgard windows and sliding doors, plumbing, hardscape in backyard and front walkway, landscaping and sprinklers, custom wood fencing, electrical wiring, 200 Amp electrical service, plumbing fixtures, water heater, pool heater, stucco, drywall, interior solid shaker style doors, solid wood front door, and so much more. ', 1966, 3, 3, 0, 1694, 5711, '6301 Newcastle Ave', '', 'Encino', 11, '91316', '34.1840433', '-118.5256366\r', 1508462902, 1508462902, 3166, 488, 8, 2),
  172. (489, 1, 16, 'Condo/Co-op, 1 beds, 1.5 baths, 1,600 sq ft.', 'Chic condo with expansive 180 degree views from Hollywood, Century City and Santa Monica to the ocean. Step out to admire the view from your balconies from the dining room or master bedroom! One large bedroom and a Den, 1.5 bathrooms with open floor-plan, High ceilings and recessed lighting. Laundry room inside. This Glen Towers unit is off of the Wilshire Corridor and features updated kitchen and baths. Close to Century City mall, Beverly Hills, Westwood and Freeways. Glen Towers amenities incl. full time doorman, Front desk reception & security, Valet parking, Grocery/luggage service, Pool, Fitness center, Garage storage, & an open outdoor space perfect for parties & events. A must see to appreciate! ', 1962, 1, 2, 0, 1600, 41379, '1333 S Beverly Glen Blvd #804', '', 'Westwood - Century City', 11, '90024', '34.063302', '-118.427102\r', 1508462903, 1508462903, 3175, 489, 54, 5),
  173. (497, 1, 1, 'Single Family Residential, 3 beds, 1.75 baths, 1,814 sq ft.', 'Rare jewel in Granada Hills!First time on the market since it was built in 1960. The house is a 3 bedroom, 2 bath with a welcoming, open ambiance you immediately feel as you walk into the light filled entry. The living room is charming with mid-century fireplace and glass doors to patio and backyard access. The kitchen also looks out on to the back patio making the back yard a wonderful part of your home. Following the architectural details throughout this house you will find tall vertical windows in the bedrooms and master suite. The back and front yards are home to beautiful mature trees and vegetation that was planned and planted by the owner. Don\'t miss the chance to make this peaceful home your own. ', 1960, 3, 2, 0, 1814, 11235, '17201 Sunderland Dr', '', 'Granada Hills', 11, '91344', '34.2919195', '-118.5090246\r', 1508462907, 1508462907, 3231, 497, 8, 2),
  174. (503, 1, 1, 'Single Family Residential, 3 beds, 1.0 baths, 1,161 sq ft.', 'Look no further! This is a rare find in the heart of NoHo art district - this home is ready for you to move in! 3 good size bedrooms (one of them was converted from a den with a gorgeous fireplace), 1 bathroom, beautiful hardwood floors, copper plumbing and professional landscaping with mature fruit trees in a spacious backyard! The patio is great for relaxing or enjoying a day of gardening. Detached generous size garage and extra long driveway make this property one of a kind with tons of potential to make it your own or add additional sqft. Conveniently located near studios, schools, shopping, restaurants & public transportation. OWNER OCCUPIED - DO NOT DISTURB WITHOUT APPOINTMENT ', 1947, 3, 1, 0, 1161, 5554, '5745 Cleon Ave', '', 'North Hollywood', 11, '91601', '34.1752108', '-118.3683687\r', 1508462910, 1508462910, 3253, 503, 1, 1),
  175. (504, 1, 1, 'Single Family Residential, 2 beds, 1.5 baths, 1,357 sq ft.', 'The Quintessential Spanish on a beautiful tree lined street in Picfair Village. The bougainvillea arbor covers you as you enter the living room w/ barreled ceilings, original HW floors and Batchelder WB fireplace. Pass thru the formal dining room to the kitchen w/ a breakfast nook these homes are known for. Adj to the kitchen is a butlers pantry on one side & entrance to the laundry room on the other. The center hall plan has a wall of original cabinetry on one side & a half bath on the other. At the end of the hall is a large remodeled full bathroom. One one side of the hall is a bedroom w/ a walk in closet & dressing area w/ built ins. On the other side is a bedroom, also w/ a small walk in closet & french doors leading to the backyard. The open & spacious backyard affords complete privacy. The rear detached garage has the beginnings of an AUD or is perfect for an art studio/man cave. The home features Central Heat/AC, new stucco, bolted foundation, restored windows, gutters & more. ', 1931, 2, 2, 0, 1357, 5453, '1617 South Stanley Ave', '', 'Los Angeles (City)', 11, '90019', '34.0461714', '-118.3629947\r', 1508462911, 1508462911, 3261, 504, 1, 1),
  176. (511, 1, 1, 'Single Family Residential, 3 beds, 3.0 baths, 1,478 sq ft.', 'Prime property in the heart of trendy Silverlake. Immaculately maintained, 2 houses on one lot. Live in one, and rent the other out to help pay your mortgage! One 2 BD/2BA home, and a separate, detached 1BD/1BA house. Not a duplex, no shared walls. Plus 2 garages(2 Car, and 1 Car). Both houses have natural hardwood floors, custom cabinets and closets, stainless steel appliances, tiled baths, and W/ D hook-ups. Houses are well cared for and could be offered furnished. Yard in need of some landscaping and finishing touches. But a great space for outdoor entertaining which includes an above ground spa. Front house has been used as a short term vacation rental for 5 years with a steady occupancy rate and income. Last annual renters paid $2000.00 a month. Short term(Airbnb/VRBO) for even more monthly income. ', 1924, 3, 3, 0, 1478, 5001, '3003 Fanita St', '', '', 11, '90026', '34.0815284', '-118.2750649\r', 1508462915, 1508462915, 3315, 511, 8, 2),
  177. (515, 1, 1, 'Single Family Residential, 2 beds, 1.0 baths, 960 sq ft.', 'Beautiful Spanish style home in a cul-de-sac in the sought after Vista Del Oro neighborhood. This two bedroom, one bath home features hardwood floors, new paint throughout, coved ceilings and newly installed Milgard® dual pane windows throughout. Newer features include air conditioning and forced air heating and a recently built single-car garage. The entire house has been renovated and is ready to become your home. The sizable finished basement has ample room for storage, a washer and a dryer and more. The long backyard extends down in two beautifully landscaped levels, each offering serene privacy and wonderful opportunities to entertain. It is home to numerous mature fruits trees and a covered seating area in the lower half of the backyard with a fountain. This is the first time that this charming home has been on the market in over 60 years. Don\'t miss out on your opportunity to own a piece of San Pedro history. ', 1924, 2, 1, 0, 960, 5739, '1204 Aldine Ct', '', 'San Pedro', 11, '90731', '33.7331642', '-118.3042412\r', 1508462916, 1508462916, 3336, 515, 1, 1),
  178. (517, 1, 1, 'Single Family Residential, 2 beds, 1.0 baths, 912 sq ft.', 'Great priced home in the Palisades area. Walk up to second level. Partial view from above in the Living room. Probate/Trust sale with court confirmation. Sold \'as is\' condition. ', 1952, 2, 1, 0, 912, 5626, '3612 S Parker St', '', 'San Pedro', 11, '90731', '33.7133846', '-118.2990977\r', 1508462918, 1508462918, 3356, 517, 1, 1),
  179. (520, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,114 sq ft.', 'Very nice and clean Property Built 1980 New for the Area 3 Bedrooms 2 Bathes Master with on Suite Updated in recent years Private Wash Room in Home . Rear Patio prefect for Parties and Family Gatherings. ', 1980, 3, 2, 0, 1114, 3359, '1555 West 59th Pl', '', 'Los Angeles (City)', 11, '90047', '33.9869461', '-118.3043147\r', 1508462920, 1508462920, 3380, 520, 8, 2),
  180. (523, 1, 29, 'Multi-Family (2-4 Unit), 3 beds, 2.0 baths, 1,346 sq ft.', 'INVESTOR\'S WELCOME TWO ON A LOT!!! FRONT HOUSE WITH A REAR UNIT OVER THREE CAR GARAGE. FRONT HOUSE HAS TWO BEDROOMS AND ONE BATH. FRONT UNIT SHOWS WELL AND IS IN VERY GOOD CONDITION. FRONT UNIT IS TENANT OCCUPIED. REAR UNIT IS LOCATED ABOVE THE THREE GARAGE AND HAS ONE FULL BEDROOM AND ONE FULL BATH. REAR UNIT IS APPROXIMATELY 480 SQ FT AS PER BUILDING PERMIT. PUBLIC RECORD ONLY SHOWS SQUARE FOOTAGE FOR FRONT HOUSE. REAR UNIT IS PERMITED AS SECOND UNIT. PERMIT AVAILABLE FOR REVIEW FOR REAR UNIT. PLEASE DO NOT DISTURB FRONT TENANT. ', 1919, 3, 2, 0, 1346, 5090, '1583 West 51st St', '', 'Los Angeles (City)', 11, '90062', '33.9970902', '-118.3062771\r', 1508462921, 1508462921, 3397, 523, 54, 5),
  181. (527, 1, 1, 'Single Family Residential, 3 beds, 1.0 baths, 1,764 sq ft.', 'The property features 4 bedrooms and 2 bathrooms with a charming fireplace in the living room. The 7,532 sqft lot is perfect for entertaining and offers lots of potential! This property truly needs to be seen to be appreciated. Close to the freeway 10, shopping, services, grocery stores and restaurants. Info herein is not verified by seller or agent. * * Please see private remarks * * ', 1923, 3, 1, 0, 1764, 7532, '2306 West 21st St', '', 'Los Angeles (City)', 11, '90018', '34.037848', '-118.3151649\r', 1508462923, 1508462923, 3428, 527, 54, 5);
  182. INSERT INTO `listings` (`id`, `owner_id`, `property_type`, `title`, `description`, `yearbuilt`, `beds`, `baths`, `sleeps`, `sqfeet`, `lotsize`, `address1`, `address2`, `city`, `state`, `zipcode`, `latitude`, `longitude`, `created`, `updated`, `id`, `listing_id`, `facility_id`, `category_id`) VALUES
  183. (528, 1, 1, 'Single Family Residential, 6 beds, 4.25 baths, 6,185 sq ft.', 'Panoramic Hollywood Hills to ocean views, just minutes from Runyon Canyon, gated and Celebrity owned Contemporary Mediterranean boasting 6 beds, 5 baths at a spacious 6185 sqft. 4 Levels, recently remodeled, wrap around balconies with views from every floor. A grand entrance greets you leading you into the great room with 2-story ceilings and expansive windows flooding you with natural light. The entire top floor is dedicated to the master suite, walk in closet, his/hers vanities, and adjacent sitting room with direct balcony access. Kitchen features a breakfast nook and seamless indoor/outdoor flow to a wraparound balcony. Separate entrances for 5 guest bedrooms and full maid\'s quarters make this an ideal live/work environment. Take the elevator down to the custom gym and office, leading out to the grassy yard with room for a pool and, of course, the unparalleled sunsets. Ample parking for 4 cars behind a custom and private security gate. Avail fully/partially furnished ', 1995, 6, 4, 0, 6185, 7440, '2651 La Cuesta Dr', '', 'Los Angeles (City)', 11, '90046', '34.1197753', '-118.3557834\r', 1508462924, 1508462924, 3431, 528, 8, 2),
  184. (529, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,112 sq ft.', 'Great Home for first time buyer; seller has completed some upgrades; Hardwood Floors in Living Room and bedrooms; Large Master bedroom addition with bath and walk-in closet was with permits; Very open eat-in kitchen; Large backyard for entertaining, kids to play or just to sit out and relax; Property should qualify for FHA and Conventional Financing; Bring your paint brush for touch-ups and move right in. Seller says submit all offers for review with approval letter, fico scores and proof of funds to close. ', 1925, 3, 2, 0, 1112, 4788, '552 West 106th St', '', 'Los Angeles (City)', 11, '90044', '33.939673', '-118.284496\r', 1508462924, 1508462924, 3438, 529, 8, 2),
  185. (531, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,296 sq ft.', 'Cosmetic fixer, great investment or ideal for the handy man ready to build some equity fast. Great opportunity to own a home for under $400,000, property is tenant occupied paying $2,500 a month could be delivered with tenants in place or vacant; up to buyer\'s needs. You won\'t find a better deal! ', 1955, 3, 2, 0, 1296, 7001, '14626 Van Nuys Pl', '', 'Panorama City', 11, '91402', '34.2465814', '-118.4513335\r', 1508462926, 1508462926, 3456, 531, 1, 1),
  186. (532, 1, 29, 'Multi-Family (2-4 Unit), 4 beds, 4.0 baths, 2,922 sq ft.', ' * * * * STANDARD SALE * * * GREAT DEVELOPMENT OPPORTUNITY * * * Please Drive By Only. Do Not Disturb Tenants. Currently there are 4 Units. According to City of Los Angeles, the property can be developed up to 6 Units. Close to shopping, public transportation and Easy access to Freeways. ', 1902, 4, 4, 0, 2922, 7500, '4465 Tourmaline St', '', 'Los Angeles (City)', 11, '90032', '34.0795839', '-118.192477\r', 1508462926, 1508462926, 3463, 532, 8, 2),
  187. (533, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,537 sq ft.', 'Interior photos available Friday morning. Beautifully updated 3 bed/2 bath Spanish in desirable mid-block location filled with light & charm. Inviting Covered arched front porch opens to entry w/ closet & window. Large living room w/ Spanish details & fireplace opens to formal dining room w/ picture window. Brand new, sunny kitchen includes quartz countertops, skylight, stainless steel appliances, and breakfast bar. Master suite w/ double closets & french doors opening to paver-tiled patio & privately landscaped yard w/ fruit trees. Master full bathroom w/ separate bath/shower & tile finishes. Features include new dual pane windows, central ac/heat, hardwood flooring, archways, recessed lighting, updated 2nd full bath, newly painted exterior, port a cochere & gated driveway. Ideal proximity to Westwood Charter School. Close to the newly renovated Century City Shopping Center, UCLA, Westwood Blvd retail & restaurants. Move-in ready! ', 1930, 3, 2, 0, 1537, 5399, '2028 Manning Ave', '', 'Los Angeles (City)', 11, '90025', '34.0493483', '-118.4279904\r', 1508462927, 1508462927, 3473, 533, 8, 2),
  188. (534, 1, 16, 'Condo/Co-op, 1 beds, 1.0 baths, 628 sq ft.', 'Terrific opportunity for buyer seeking cosmetic fixer property. Open floor-plan on this 1 bedroom and 1 bathroom condominium which features natural streaming sunlight and in prime Canoga Park location. Living room area with a sliding glass door that opens to front balcony. Well-sized bedroom with generous walk-in closet. Galley kitchen has breakfast bar with lots of cabinet storage and counter space. Tile floors make for easy cleanup and low maintenance. Open garden style building is secured with intercom system, enclosed community pool, laundry room and two covered parking spaces plus storage located near unit. Low HOA fee even includes water and gas. Close to shopping, malls, restaurants and easy access to mass transportation and major freeways ', 1976, 1, 1, 0, 628, 34702, '20930 Parthenia St #201', '', 'Canoga Park', 11, '91304', '34.2279888', '-118.5899859\r', 1508462927, 1508462927, 3481, 534, 54, 5),
  189. (538, 1, 1, 'Single Family Residential, 4 beds, 5.0 baths, 5,660 sq ft.', 'The One & Only ! Iconic Entertainer\'s dream home offering Jaw dropping panoramic views ! In the exclusive gated Viewmont private enclave above the Sunset Strip, this stunning sophisticated and remarkable 3 story modern architectural offers spectacular jetliner city-to-ocean views from all rooms ! Apx 6000 Sq. Ft. 4 beds, 6 baths, office, massive 12 seats home theater w/ bar, finest quality & warm finishes, high ceilings, walls of glass, spacious living & dining area + gourmet kitchen w/ top quality appliances. Open Floor Plan - 3 Fireplaces - Flat screens in every room, lots of closet space. The master suite boasts spectacular panoramic city & ocean views - Luxurious master bath equipped w/ spa tub, multiple shower heads + huge walk-in-closet. Gorgeous outdoor deck, infinity pool & jacuzzi overlooking gorgeous views. 2 Car garage & Private driveway can fit up to 5 cars. Incredible beauty, sophistication, & in impeccable condition. ', 2008, 4, 5, 0, 5660, 7089, '1724 Viewmont Dr', '', 'Los Angeles (City)', 11, '90069', '34.102781', '-118.3798431\r', 1508462929, 1508462929, 3504, 538, 1, 1),
  190. (545, 1, 1, 'Single Family Residential, 5 beds, 4.75 baths, 3,321 sq ft.', 'Unbeatable beach, city, and mountain views! This contemporary home is located at the heart of Playa Del Rey\'s exclusive beachside community. Enjoy coffee shops, acclaimed restaurants, specialty markets, local nightlife, miles of bike paths, and serene beaches. Starring 3,300 sqft of contemporary design, 229 Montreal boasts two stories, 5 BR, 5 BA, and an open, sunny floor plan. Catch sunrise, sunset views from the fully-equipped master suite featuring a romantic fireplace, large sitting area, rejuvenating steam shower, and oversized spa tub. The ample kitchen is flooded with natural light and sits at the center of the home. Semi-partitioned by a fireplace, the joined dining and living rooms boast a bar overlooking the room and onto panoramic views. This longtime owner-occupied home features a custom wooden staircase, generous 2-car garage, abundant storage space, and central air and heating. Private entry guest studio is complete with a full kitchen and bathroom for total privacy. ', 1969, 5, 5, 0, 3321, 3695, '229 Montreal St', '', 'Playa Del Rey', 11, '90293', '33.9587038', '-118.4476932\r', 1508462935, 1508462935, 3563, 545, 8, 2),
  191. (546, 1, 1, 'Single Family Residential, 5 beds, 5.0 baths, 3,598 sq ft.', 'An incredible opportunity to design and build an expansive estate of up to 12,000 square feet on one of the most coveted streets in Beverly Hills. Situated among multi-million dollar homes minutes from The Beverly Hills Hotel, and Rodeo Drive\'s world-class shopping and dining, this prime development lot consists of 51,929 square feet of mostly flat, buildable land with sweeping views of Century City, the Wilshire Corridor, and the ocean. A rare opportunity to enjoy the quintessential Beverly Hills lifestyle and construct a fully customized, luxury estate. ', 1960, 5, 5, 0, 3598, 51929, '1463 Claridge Dr', '', 'Beverly Hills', 11, '90210', '34.0978595', '-118.4214227\r', 1508462935, 1508462935, 3570, 546, 54, 5),
  192. (549, 1, 1, 'Single Family Residential, 3 beds, 3.0 baths, 2,349 sq ft.', 'Newer built house on a quiet street. Home features 3 bedrooms, 3 bathrooms plus an office that can be used as a 4th bedroom. Bright living room with high ceilings, separate dining area, open kitchen with granite countertops and stainless steel appliances. Spacious master bedroom with a walk in closet and balcony over looking the yard. Master bath comes with his and hers sink, shower and soak tub. Landscaped backyard made for entertaining guests! ', 2007, 3, 3, 0, 2349, 284574, '12101 Van Nuys Blvd #25', '', 'Sylmar', 11, '91342', '34.286015', '-118.396615\r', 1508462937, 1508462937, 3586, 549, 1, 1),
  193. (552, 1, 1, 'Single Family Residential, 6 beds, 3.0 baths, 2,592 sq ft.', 'Standard sale Great opportunity to own a spacious 6 bedrooms 3 bath with a detached 2 car garage long driveway new tile floor new carpet new plumbing new electric system kitchen with granite counter tops new paint inside and outside central air conditioner separate laundry room just minutes from the new LA Rams stadium ', 1938, 6, 3, 0, 2592, 7863, '8907 S Van Ness Ave', '', 'Inglewood', 11, '90305', '33.9570499', '-118.3180869\r', 1508462939, 1508462939, 3602, 552, 1, 1),
  194. (553, 1, 1, 'Single Family Residential, 3 beds, 1.0 baths, 1,192 sq ft.', 'This is an amazing 3 bedroom home in Wilmington, with tons of pride in ownership. Great curb appeal boasts a newer custom built wrought iron fence with beautiful landscape. There are beautiful palm trees in the front, with custom tile work in the front outside wall. It also has thick high end tile used on the steps towards the entrance of the home. As you enter you will fall in love with the custom dark rustic hardwood floors through most of the house. The newer double pane windows with custom built trim around it to purposefully look like the era the home was built in. Large rooms throughout. Each room has custom closets to efficiently maximize the space. Open Kitchen with tile counter tops and wood cabinets. The kitchen also has custom tile flooring and access to washer and dryer. There is newer central AC and heating unit in the attic. The living room has a working fire place to enjoy in the colder days. The bathroom is completely remodeled with beautiful custom tile. The garage was recently done from the ground up. PLUS additional large storage room for tools and such. It has large lot with concrete driveway with tons of space for multiple cars. Large yard to enjoy family BBQ’s. Sprinkler system with 3 pumps. The property is zoned for R2. This is an absolute must see…don’t walk, RUN and COME SEE THIS HOME. ', 1925, 3, 1, 0, 1192, 6719, '1320 Eubank Ave', '', 'Wilmington', 11, '90744', '33.789886', '-118.2558982\r', 1508462939, 1508462939, 3611, 553, 54, 5),
  195. (561, 1, 1, 'Single Family Residential, 2 beds, 1.0 baths, 968 sq ft.', 'Views and more views from all areas of the home and yard. Balcony view shows beautiful evening lights. There are updates throughout this 2 bedroom and 1 bath home. The enchanting living room fireplace is waiting to be enjoyed. Relax on the patio sipping cool beverages from the new wine cooler. Updates in the kitchen and bath include new Whirlpool and Frigidaire appliances, Hansgrohe and Fluid faucets. This great home also includes an exterior tankless water heater. There is a new washer and dryer in the laundry room. The 2 car garage is accessible from the street. Smart home type features include USB port wall outlets, WiFi Thermostat and wall switch by front door are accessible through apps. ', 1957, 2, 1, 0, 968, 4973, '4919 Argus Dr', '', 'Eagle Rock', 11, '90041', '34.1364827', '-118.2064862\r', 1508462944, 1508462944, 3662, 561, 54, 5),
  196. (572, 1, 29, 'Multi-Family (2-4 Unit), 6 beds, 4.0 baths, 4,521 sq ft.', 'Attention FIXER, Investor, 1031 Exchange Buyers and Owner-Users. This is as good as it gets, character Spanish upstairs-downstairs duplex in prime Miracle Mile-Hancock Park adjacent neighborhood, with upside! Features hardwood floors, arched doorways, coved ceilings, step down living room, decorative fireplaces, high ceilings, leaded-stained glass windows and original charm throughout. Each unit has 3 large bedrooms & 2 baths with room to easily add an additional full bath. 4 car garage parking in rear. Downstairs unit will be delivered vacant at close of escrow. Upstairs unit is tenant occupied with tenant rights, leased at $3000 on a month-month lease. This is an AS-IS sale. No showings inside upstairs, tenant occupied unit without an accepted offer. Prime rental location near popular restaurants, shops, transportation and city services. Deadline for offers, will be posted on the MLS soon. Please, DO NOT DISTURB OCCUPANTS, Thank You. This one will go fast! ', 1930, 6, 4, 0, 4521, 6600, '119-119-121 South Detroit St', '', 'Los Angeles (City)', 11, '90036', '34.0729929', '-118.3454111\r', 1508462950, 1508462950, 3732, 572, 8, 2),
  197. (577, 1, 1, 'Single Family Residential, 6 beds, 3.0 baths, 2,370 sq ft.', 'Convenient Location, Location, Location!!! Zoning R4, Perfect Investment opportunity for Condo or Apartment. 4 bedrooms on the 2nd floor. This property has a preschool license. preschool for 25 children and after school for 7 children. It is 4 bedrooms and 3 bathrooms, 2 bathrooms w/ o permit. This property is sold in \'AS-IS\' condition. ', 1908, 6, 3, 0, 2370, 7506, '851 South Manhattan Pl', '', 'Los Angeles (City)', 11, '90005', '34.0565526', '-118.3104341\r', 1508462953, 1508462953, 3765, 577, 1, 1),
  198. (579, 1, 29, 'Multi-Family (2-4 Unit), 6 beds, 4.0 baths, 1,825 sq ft.', 'Great Units Built in 2009.. 3 bed 2 bath each. 2 car attached garage and both with inside laundry. .Don\'t miss out. ', 2009, 6, 4, 0, 1825, 5120, '844 W 54th St', '', 'Los Angeles', 11, '90037', '33.992983', '-118.288693\r', 1508462954, 1508462954, 3784, 579, 54, 5),
  199. (591, 1, 1, 'Single Family Residential, 5 beds, 4.0 baths, 3,771 sq ft.', 'NEWLY REMODELED 2 - STORY HOUSE WITH HIGH END UPGRADES 5 BEDROOM/4 BATHROOM. ALMOST 3800 SQUARE FEET OF LUXURY AND SPACE FOR LARGE FAMILY AND/ OR ENDLESS ENTERTAINMENT. LOCATED SOUTH OF BLVD ON A BEAUTIFUL QUET TREE-LINED CUL-DE-SAC. LARGE FOYER, OPEN FLOOR FORMAL LIVING & DINING ROOMS AND A WET BAR WITH WINE REFRIGERATOR. A FLOOR TO CEILING DOUBLE FIREPLACE SEPARATES THE LIVING AND A FAMILY ROOMS. BOTH HAVE FRENCH DOORS TO A COVERED PATIO AND GRASS AREA. 2 MASTER SUITES ( 2ND STORY WITH VIEW) JACK & JILL BEDROOMS, BONUS ROOM FOR GUESTS OR OFFICE. A CHEF\'S KITCHEN IS OPEN TO A BREAKFAST AREA AND A FAMILY ROOM, LARGE ISLAND WITH NEW COUNTERS, LOADS OF STORAGE AND MICROWAVE DRAWER. STAINLESS STEEL APPLIANCES INCLUDE A 48\" VIKING RANGE AND 48\" BUILT-IN REFRIGERATOR/FREEZER. RECESSED LIGHTING; DUAL PANE WINDOWS; CENTRAL AIR ON BOTH FLOORS. HARDWOOD FLOORS THROUGHOUT. ALARM AND SURROUND SOUND SYSTEM INSTALLED. ATTACHED 2-CAR GARAGE+DRIVEWAY FOR PARKING; HOUSE LOCATED IN AWARD WINNING WILBUR CHARTER SCHOOL, CLOSE TO BRAEMAR AND EL CABALLERO CLUBS. . ', 1963, 5, 4, 0, 3771, 11141, '18609 Palomino Dr', '', 'Tarzana', 11, '91356', '34.1506951', '-118.5375804\r', 1508462960, 1508462960, 3864, 591, 54, 5),
  200. (593, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,395 sq ft.', 'Beautiful home in a great area of Los Angeles, Property has been completely renovated form new Floor, Paint, Bathroom jet tub Jacuzzi, New windows, good size room, great lay out great size lot. appliance included in the sale. Huge Master bedroom with its own personal bathroom. Bring your pickiest buyer they will love it ', 1929, 4, 2, 0, 1395, 5400, '235 E 106th St', '', 'Los Angeles', 11, '90003', '33.9403679', '-118.2705113\r', 1508462962, 1508462962, 3877, 593, 54, 5),
  201. (596, 1, 1, 'Single Family Residential, 8 beds, 8.0 baths, 6,914 sq ft.', '', 1968, 8, 8, 0, 6914, 27536, '903 Linda Flora Dr', '', 'Los Angeles (City)', 11, '90049', '34.0839283', '-118.4653722\r', 1508462963, 1508462963, 3902, 596, 54, 5),
  202. (598, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 753 sq ft.', 'Located steps away from trendy Figueroa in Highland Park we present this beautifully remodeled ground floor condo that features 2 bedrooms/2 bath w/ designer finishes. The new kitchen features gloss white cabinetry w/ built in oven, beautiful marble counters, cook-top, microwave & Bosch dishwasher. Private laundry in unit, new wood floors in the living spaces along w/ new paint. Wood doors w/ frosted glass inserts to bedrooms, Nest smoke detector & spacious closets. Located as an end unit in the 5860 building, there is only one shared wall. Other features include a spacious private patio overlooking the swimming pool. Amenities: Pool, Spa, Sauna Room, BBQ\'s, Recreation Room, Fish Pond, Picnic & green belt, Children\'s Play Area, Basketball Sport Court, 3 Elevators, and Dog Run. This condo has it all! ', 1979, 2, 2, 0, 753, 311572, '5860 Benner St #103', '', 'Los Angeles (City)', 11, '90042', '34.106724', '-118.189909\r', 1508462964, 1508462964, 3910, 598, 8, 2),
  203. (599, 1, 11, 'Mobile/Manufactured Home, 3 beds, 2.0 baths, 1,541 sq ft.', 'Brand New ARCHITECTURAL manufactured home is 1541 SqFt. 3 bedroom / 2 bathroom with a Incredible CHEF\'S ISLAND with large counter space . Near 10 foot flat ceiling through ENTIRE home. Walls of glass. Spa like master bath, with his and hers sinks, huge tub and an incredible Italian stone shower the dual shower heads. Entire home encircled with upper windows just below roof line. Open floor plan, huge living room with fireplace. Entire home bathed in light. Incredibly energy efficient. Quiet, safe location walking distance to park, shops, and Mall. Land rent protected by Rent Control. No HOA dues. No real estate property taxes. ', 2017, 3, 2, 0, 1541, 0, '25 Essox Unit -', '', 'Northridge', 11, '91324', '34.232575', '-118.5512543\r', 1508462965, 1508462965, 3925, 599, 54, 5),
  204. (600, 1, 1, 'Single Family Residential, 3 beds, 1.0 baths, 1,418 sq ft.', 'Nice three bedroom with a den addition. Odd shape lot is perfect for those family gatherings Home is in good condition. Bring your family. Great potential for adding that special touch. ', 1944, 3, 1, 0, 1418, 5298, '9628 Success Ave', '', 'Los Angeles', 11, '90002', '33.9482467', '-118.2488195\r', 1508462965, 1508462965, 3927, 600, 8, 2),
  205. (602, 1, 1, 'Single Family Residential, 5 beds, 3.5 baths, 2,353 sq ft.', 'Currently a very lucrative & well-maintained vacation rental that approximately grossed $200K in 2017 & $280K in 2016! This gorgeous Spanish home with a new saline pool & infinity spa was completely reconstructed, expanded and beautifully revived in 2014. Nestled in a fully gated and privately hedged secret garden, this sanctuary welcomes you with a magical front courtyard. The home features a rare one-story 5 BD, 3.5 BA floorplan exuding endless charm with its arched entryways, french doors throughout, dark hardwood floors, & a fireplace. Unique to this home are its multiple outdoor entertaining & seating areas off the living, dining, & the bedrooms perfect for families who enjoy a seamless indoor-outdoor feel. The open concept gourmet kitchen prides itself with a large island laid in Carrara marble and is equipped with top of the line commercial grade Viking appliances. Best of all, this home is a stroll to Trader Joes and Sprouts food markets, cafes, & restaurants of Melrose Street. ', 1923, 5, 4, 0, 2353, 6450, '903 North Vista St', '', 'Los Angeles (City)', 11, '90046', '34.087266', '-118.352588\r', 1508462966, 1508462966, 3938, 602, 8, 2),
  206. (617, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,392 sq ft.', 'Perfect starter home, located in a peaceful neighborhood. The nearby schools are very good and include Redeemer Lutheran School, Autism Academy and Ivy Bound Academy Math Science And Technology Charter Middle 2. The property has a great floor plan and very large nicely landscaped backyard. Must see to appreciate. ', 1955, 3, 2, 0, 1392, 8190, '8518 Penfield Ave', '', 'Canoga Park', 11, '91306', '34.2252487', '-118.5685384\r', 1508462975, 1508462975, 4034, 617, 54, 5),
  207. (618, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 2,053 sq ft.', 'This spacious and exceptionally well-appointed single-level home offers a wonderfully versatile open floor-plan with ample private spaces for a growing or mature family. It\'s move-in ready with a tastefully remodeled open kitchen, formal dining room, living room and very generous family room that opens out to backyard patio. There are three good-sized bedrooms, remodeled hall bath with vessel sink and an exquisite, private master-suite retreat with huge walk-in closet and elegantly remodeled master bath. Quality wood and stone flooring, crown moldings, recessed lighting, all new dual-pane doors and windows and custom plantation-shutters throughout the home. HVAC system has been completely replaced in the last few years and there\'s an energy-saving tankless water heater. Detached 2-car garage accessed at alley and ample off-street parking in front driveway. Low-maintenance exterior. Low-traffic street in a great neighborhood. ', 1944, 4, 2, 0, 2053, 6361, '1444 W 2nd St', '', 'San Pedro', 11, '90732', '33.7427119', '-118.3074965\r', 1508462975, 1508462975, 4041, 618, 54, 5),
  208. (619, 1, 1, 'Single Family Residential, 5 beds, 5.0 baths, 4,560 sq ft.', 'Absolutely stunning panoramic views delivered in the comfort of this beautiful home. Situated south of boulevard and north of Mulholland, you will feel like a bird overlooking the valley. There is a view from each room of this home. Presenting 5 bedrooms, 4.5 baths in this 4560 sf home perched above the city, this home will offer you luxurious finishes throughout: granite, travertine, solid oak, and much more! A generous, open floor plan, the home has 3 levels which includes an elevator and laundry chute. An entertainers delight with outdoor deck in both living spaces, an outdoor patio that runs the length of the property and a roof top patio when you feel like being on the “top of the world” while watching the city below! Vikings live in the kitchen for those discriminating chefs who love to cook. A great breakfast bar and wine closet are also residents here. The Master Suite is spacious and flows into the dreamy master bath with decadent extras such as a fireplace, shower featuring 2 steam shower heads with 2 body sprays,   step up to a deep tub and soak in the panoramic views! Plenty of space for a large family or plenty of guests! ', 2005, 5, 5, 0, 4560, 25356, '3940 Oakfield Dr', '', 'Sherman Oaks', 11, '91423', '34.1420758', '-118.4462361\r', 1508462976, 1508462976, 4044, 619, 8, 2),
  209. (621, 1, 1, 'Single Family Residential, 3 beds, 1.0 baths, 1,222 sq ft.', 'Adorable 3 bedroom, 1 bath house with pool located in a quiet neighborhood of Panorama City. This gated home offers plenty of parking in the front. In addition it offers a large open living room space with fireplace, dining room, kitchen with updated cabinetry, and an entertainer\'s backyard. The bedrooms have plenty of natural lighting. The garage has been converted with a 3/4 bath and kitchen counter (buyer to verify permits). Furthermore, there is a small guest house in the back of the house (buyer to verify permits). Hurry this home will not last. ', 1949, 3, 1, 0, 1222, 7238, '8508 Minuet Pl', '', 'Panorama City', 11, '91402', '34.2250175', '-118.4331608\r', 1508462977, 1508462977, 4058, 621, 8, 2),
  210. (624, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 1,556 sq ft.', 'A creative penthouse live/work loft in S. Park. This energetic light filled unit with a sizable floor plan has defined industrial/modern architectural features throughout, 15\' open ceilings, exposed AC ducting, floor to ceiling walls of operable double-paned windows, an all purpose modern kitchen excellent for entertaining & cooking, two full private bathrooms with walk in closets at opposite ends, a cold rolled steel sliding enclosure for second bedroom/office use, and a rolled steel magnetic accent wall. Master Bedroom has sheer curtains for the enclosure. Two assigned parking spaces, 1 covered withaccess to EV Charging Station. In unit laundry! Grand Lofts is located in South Park, home to Entertainment Venues (Staples Center/LA Live). You are steps away to all the conveniences that DTLA has to offer (Metro, Wholefoods, FDIM, Macy Bloc, Freeway Access, USC, Cal Hospital, dozens of restaurants & coffee shops, shopping and more! Amenities and covered parking to be delivered in 2019. ', 2005, 2, 2, 0, 1556, 18467, '330 West 11 St #704', '', 'Los Angeles (City)', 11, '90015', '34.0411641', '-118.2618509\r', 1508462978, 1508462978, 4082, 624, 54, 5),
  211. (627, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,632 sq ft.', 'The owner has identified replacement property and needs to sell fast. Description and pictures are coming soon! ', 1954, 4, 2, 0, 1632, 11202, '6901 Cozycroft Ave', '', 'Winnetka', 11, '91306', '34.1953235', '-118.5799588\r', 1508462980, 1508462980, 4098, 627, 1, 1),
  212. (629, 1, 1, 'Single Family Residential, 3 beds, 1.0 baths, 1,184 sq ft.', 'Welcome to 7037 Louise Ave! First time on the market in over 40 years. This 3 bedroom, 1 bath Lake Balboa home is perfect for the first time home buyer, investor, or savvy home buyer who is ready to turn their vision into reality. Well maintained and very clean, enabling you to move in right away and renovate over time. This house is begging for an open floor concept and center kitchen island. And with a huge 9,700 square foot lot, expansion possibilities are endless! Hurry, this home will not last! Home to be sold \"as-is\". ', 1951, 3, 1, 0, 1184, 9749, '7037 Louise Ave', '', 'Van Nuys', 11, '91406', '34.198545', '-118.5101299\r', 1508462981, 1508462981, 4110, 629, 8, 2),
  213. (631, 1, 16, 'Condo/Co-op, 3 beds, 2.5 baths, 1,554 sq ft.', 'Penthouse Apartments, with a combined breathtaking 270 degree wrap-around views of Ocean White Water, Panoramic City, Santa Monica Mountains, and balcony\'!! . A Twin Tower Complex with full service and great amenities: 24 hour valet parking & security, pool, spa, gym, maid service is available, concierge and more -- the convenience of a luxury hotel with all the comforts of home. Brand new dark wood floors, 4 new plasma t. v. \'s, brand new bathrooms. Unit next door is also available for purchase. Building is a co-op. Buyer assumes mortgage. See private remarks. ', 1971, 3, 3, 0, 1554, 38608, '201 Ocean Ave Unit P1904', '', 'Santa Monica', 11, '90402', '34.0270978', '-118.5143597\r', 1508462982, 1508462982, 4124, 631, 8, 2),
  214. (639, 1, 29, 'Multi-Family (2-4 Unit), 1 beds, 2.0 baths, 1,548 sq ft.', 'Less than one mile from Huntington Park and 5 miles south of Downtown Los Angeles Art district. Good property to live and work. Store in front with apartment in the back with garage. The tenant of the store pays $1,100 per month and has a lease until 3/31/2018. The rear one bedroom apartment with garage was remodeled in 2016 and the tenant pays $1,250 and is now on a month to month. There\'s also additional monthly income of 41.66 from the billboard. Financing Available see below: 1st Trust Deed. . a 1003 Application needed from the new buyer… New loan of $245,000.00 6.95% rate Amortized over 30 years, due in 5 years, Payments would be $1,621.77 a flat fee of $7,000 for loan origination fee. Or if the new buyer wants to assume the existing loan: 1003 loan application… Balance is $189,686.26 Interest rate of 6.95% Monthly payments of $1,157.00 An assumption fee of $5,000.00 ', 1921, 1, 2, 0, 1548, 2600, '6126 Holmes Ave', '', 'Los Angeles', 11, '90001', '33.9839485', '-118.2409152\r', 1508462987, 1508462987, 4183, 639, 8, 2),
  215. (642, 1, 1, 'Single Family Residential, 5 beds, 4.5 baths, 3,600 sq ft.', 'Located two blocks from Santa Monica, this spacious 3,600 sqft Farmhouse is an exceptional and unique addition to the West Side. With voluminous 10ft ceilings and an elegant blend of rustic finishes, 2493 Amherst truly feels like home. High quality finishes throughout this BRAND NEW CONSTRUCTION. A 12ft bifolding door creates an expansive opening for indoor/outdoor living. The marble island kitchen, with walk-in pantry and butler\'s prep area is truly a chef\'s dream, with the full range of Jenn Air\'s Professional Series appliances: 48\" dual oven range with built in flat-top grill and heat-lamp matching hood, 42\" french door refrigerator with easy-to-clean black interior and built in microwave, dishwasher, and espresso machine. All real wood custom cabinetry throughout the kitchen and two mudrooms. Restoration hardware vanities in the bathrooms, accented by designer lighting and mirrors. Enormous Master Suite offers custom finished His & Her Closets, Vaulted Ceilings, private balcony, and intimate fireplace. The master bathroom features gorgeous brushed brass finish fixtures and a 90inch restoration hardware floating dual vanity. The 7ft shower makes your master bath a truly spa-like retreat. Fully wired throughout for Surround Sound, Home Automation, High Speed Internet and Security Systems, this eco-friendly smart-home offers a tankless water heater, energy efficient HVAC, upgraded dual-pane thermally broken Andersen Fiberx Windows, and more! Don\'t miss this home! ', 2017, 5, 5, 0, 3600, 5246, '2493 Amherst Ave', '', 'West Los Angeles', 11, '90064', '34.0267095', '-118.4495454\r', 1508462988, 1508462988, 4201, 642, 1, 1),
  216. (650, 1, 1, 'Single Family Residential, 2 beds, 2.0 baths, 1,134 sq ft.', 'Live in one of the most desirable areas in all of Los Angeles. This stunning contemporary Spanish home includes 2 bed/2 baths, designer kitchen with marble counters & professional appliances. Property has been upgraded throughout: hardwood floors, recessed lighting, french-doors in dining room opens to intimate garden patio. Custom built-in closets in bedrooms. Surround sound throughout home and exterior. Four camera hardwired security system with custom designed Crestron Control home automation system. French door exits from both bedrooms leading out to entertainers backyard with saltwater pool, surrounded by lit dining area and entertaining space with custom built fire pit. Professionally designed drought tolerant landscaping on auto-drip system. LED exterior lighting surrounds property. ', 1926, 2, 2, 0, 1134, 4004, '8814 Rosewood Ave', '', 'West Hollywood', 11, '90069', '34.0777981', '-118.3844069\r', 1508462994, 1508462994, 4266, 650, 8, 2),
  217. (651, 1, 1, 'Single Family Residential, 3 beds, 1.75 baths, 1,728 sq ft.', 'This single level charming home has been recently updated and remodeled to please any buyer and is in move in condition. This home features open floor plan with plenty of living space , 3 bedrooms and 1 3/4 bathrooms, with updated cabinets and granite vanity tops, kitchen cabinets and granite counter tops, new appliances, new cabinets in both bathrooms and updated 1 full bath with tiles and new tub and toilet. the walls have all been painted with warm colors, Nice laminate flooring through out the house, central air and heat- new air ducts in place, long driveway for more parking space and lots more. A MUST SEE TO APPRECIATE. ', 1938, 3, 2, 0, 1728, 6598, '1803 S Bronson Ave', '', 'Los Angeles', 11, '90019', '34.0415438', '-118.3291732\r', 1508462994, 1508462994, 4280, 651, 54, 5),
  218. (657, 1, 1, 'Single Family Residential, 5 beds, 5.0 baths, 4,989 sq ft.', 'Sleek and sexy architectural with an expansive open floor plan and great square footage in one of the most coveted areas of West Hollywood. Soaring ceilings with floating wood flanks, pendulous glass railed open-tread staircase, reclaimed wood finishes, venetian plaster accents and architectural detail throughout. Luxurious and open one of a kind Italian Kitchen opens to living and family rooms creating an open loft feel. Enjoy the true LA experience, where the outdoor and indoor environment become synonymous. Through Fleetwood doors opening to an expansive wood deck and pool with swim-up bar and water feature, built-in bbq and dining area off the kitchen for al fresco dining. Stylish master suite with spa bath and deep soaking tub, two generous walk-in closets and a large balcony, plus 4 additional bedroom suites. A beautiful gated entrance with water garden, planter boxes & the unique blending of reclaimed wood & metal finishes give the space and true art gallery feel. ', 2016, 5, 5, 0, 4989, 6550, '824 North La Jolla Ave', '', 'Los Angeles (City)', 11, '90046', '34.086146', '-118.367702\r', 1508462997, 1508462997, 4311, 657, 1, 1),
  219. (658, 1, 1, 'Single Family Residential, 2 beds, 1.0 baths, 1,052 sq ft.', 'Great Opportunity! Lovely home for the first time buyer or investor. Close to all amenities in Los Angeles. Please drive by only!! Do not disturb tenants. ', 1927, 2, 1, 0, 1052, 2648, '4117 Zamora St', '', 'Los Angeles (City)', 11, '90011', '34.0087169', '-118.2531438\r', 1508462998, 1508462998, 4329, 658, 54, 5),
  220. (661, 1, 1, 'Single Family Residential, 5 beds, 5.5 baths, 0 sq ft.', 'New Construction with one of the Biggest views in the city! Rising up from one of the last great promontory view sites along Sunset Strip is a One of a kind contemporary, designed by world renowned Belzberg Architects. Explosive views spanning Downtown Los Angeles all the way west to Century City and the Ocean beyond. Located one minute from Sunset Strip and legendary Hollywood establishments such as Chateau Marmont and The Sunset Tower Hotel as well as the new Flagship Fred Segal, Equinox Fitness and all the fine dining on Sunset Plaza. A minimalist but warm material palette is displayed throughout the interiors. A design that cannot be replicated under current planning laws, this exquisite home features 5 bedrooms, zero edge infinity pool, Gym, Theater, Climate Controlled Wine Room and rare Off-street parking for 7 cars. Location, Architecture & Views - Live above it all. Shown to Pre-Qualified Buyers Only. ', 2017, 5, 6, 0, 0, 11687, '8516 Hedges Pl', '', 'Los Angeles (City)', 11, '90069', '34.0962871', '-118.3773995\r', 1508463000, 1508463000, 4346, 661, 1, 1),
  221. (670, 1, 16, 'Condo/Co-op, 1 beds, 1.0 baths, 641 sq ft.', 'Excellent opportunity to be in the heart of Westwood. One bedroom and one bathroom condo with a patio area. Granite counter tops and stainless steel appliances. Complex has controlled key access to lobby and subterranean gated parking, on-site manager, lounge with billiards, card tables, television and sectional seating. There is a pool, BBQ area, gym, baseball court and community laundry room. Perfect for a student, professional or investor that wants a convenient location. Close to Westwood Village, UCLA, restaurants, theaters, most services and public transportation. ', 1973, 1, 1, 0, 641, 0, '10982 Roebling Ave #359', '', 'Los Angeles (City)', 11, '90024', '34.064589', '-118.4491594\r', 1508463010, 1508463010, 4400, 670, 8, 2),
  222. (674, 1, 40, 'Townhouse, 2 beds, 2.5 baths, 1,218 sq ft.', 'Here is your opportunity to acquire an amazing 2 bedroom, 2.5 bath townhouse just blocks away from Ventura Blvd. and the trendy shops and restaurants at the \"Village Walk, \" including Whole Foods Market, Starbucks, Blu Jam Café, Beat Bike, Yoga Works, and much more. This tri-level unit features two master suites (each bedroom is spacious and boasts a full-attached bathroom and walk-in closet), your own private washer and dryer inside your unit, and a large living room that opens to a private front patio (this unit being one of only 3 in the complex that has accessible power on the patio). Parking is a breeze with two side-by-side assigned spots in the underground, gated garage adjacent to a door which provides convenient direct access into the unit. Just in front of your parking spots is ample storage space with built-in wood storage containers. HOA includes hot and cold water, trash, security cameras in the garage and at both entrances, as well as maintenance of the pool, jacuzzi, and common areas. HOA recently completed a renovation of the common areas that included resurfacing the main walkway that runs through the middle of the complex to provide better water resistance (in conjunction with new, improved drainage), in addition to replacing the deck material on each unit\'s private patio (where my clients opted for the upgraded stamped concrete finish). This one definitely will not last! ', 1975, 2, 3, 0, 1218, 41537, '18631 Collins St #11', '', 'Tarzana', 11, '91356', '34.1753121', '-118.5394697\r', 1508463014, 1508463014, 4426, 674, 8, 2),
  223. (679, 1, 1, 'Single Family Residential, 6 beds, 7.0 baths, 4,653 sq ft.', 'Spectacular view property down a very private country lane on a cul-de-sac directly off the world famous star studded Mulholland Dr. The property is situated on a promontory, overlooking stunning city views. The property has an open floor plan with great scale and proportions. The first floor consists of 2 bedroom suites, great room, kitchen breakfast room, office, and formal dining room. The second floor consists of 4 bedrooms 4 bath of which 2 of them are master suites, and an office. The pool looks out onto jetliner views of city lights and lush greenery. ', 1963, 6, 7, 0, 4653, 7028, '13431 Java Dr', '', 'Beverly Hills', 11, '90210', '34.1301853', '-118.4258222\r', 1508463018, 1508463018, 4447, 679, 1, 1),
  224. (684, 1, 1, 'Single Family Residential, 6 beds, 8.5 baths, 9,733 sq ft.', 'Artistic East coast traditional architectural masterpiece in Colfax Meadows, named by Los Angeles Magazine as One of the Ten Best Neighborhoods in LA! CARPENTER SCHOOL DISTRICT! Cutting-edge technology & design with fully integrated Control 4 smart home system, two staircases and an elevator to all floors. Bottom floor features:Temperature-controlled wine cellar, private gym, state of the art theater room, dry sauna plus jacuzzi and two huge master suites. Main floor: Gorgeous dinning, living and family room. A true chef\'s kitchen with two separate 36\" Sub Zero refrigerators and a 36\" Freezer. High quality custom cabinetry, built-in Wolf package including: double oven, microwave, warming drawer and coffee machine. Spacious office plus a full master bedroom. An Oasis of a back yard that has a feel of a high end luxury resort with zero edge pool, spa, bbq area, custom cabana, sports court and putting range. Upper level: four additional large masters but the grand master suite is truly one of a kind with a stunning master bath with free-standing tub, steam shower, make-up area and much more. ', 2017, 6, 9, 0, 9733, 16530, '11560 Dilling St', '', 'Studio City', 11, '91604', '34.142851', '-118.384549\r', 1508463023, 1508463023, 4479, 684, 8, 2),
  225. (686, 1, 47, 'Vacant Land, beds, baths, 0 sq ft.', 'Lot is located with hilly terrain giving it opportunity to build with view. Great opportunity to build private retreat. Hidden from street view access is behind home on Redmont and Valaho. Featured at base of hill. ', 0, 0, 0, 0, 0, 1513, '7326 valajo Ln', '', 'Tujunga', 11, '91042', '34.249737', '-118.2926476\r', 1508463025, 1508463025, 4501, 686, 54, 5),
  226. (695, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 2,558 sq ft.', 'Welcome to Cooper Place! A collection of 4 brand new single-family homes located on a cul-de-sac street in a great neighborhood! Each home has 4 bedrooms + 3 full baths with an upstairs den! There is a nice wide Foyer with a downstairs bedroom and full bathroom! The gourmet kitchen features a center island with lots of drawers, quartz counter tops with glass back splashes, stainless steel appliances including a café style refrigerator/freezer, two ovens, a microwave, dishwasher and a large pantry area. The home has lots of light and a nice open floor plan with the dining area opening to the living/family room with fireplace that leads out to the expansive rear yard! The upstairs has 3 bedrooms and two full baths, a nice size den, a large storage cabinet and a full-size laundry room! The sumptuous master suite has a walk-in closet, soaking tub and separate shower! The other two generous size bedrooms have a Jack and Jill bath set up with a shower/tub combo! Downstairs is wood flooring with tile in the bathrooms! The living area of each home ranges from approximately 2,450-2,557 square feet on almost 6,000 square foot lots! The floor plans are the same on each home! The model home fronts on Community street while the 3 others are located on Cooper Place a private street of 5 homes! The pictures shown in the MLS are of the model home! Each home comes with full frontal landscaping! ', 2017, 4, 3, 0, 2558, 7793, '8336 Cooper Pl', '', 'Winnetka', 11, '91306', '34.2048586', '-118.5739621\r', 1508463035, 1508463035, 4559, 695, 54, 5),
  227. (703, 1, 16, 'Condo/Co-op, 1 beds, 1.0 baths, 0 sq ft.', 'Very nice and clean Property Built 1980 New for the Area 3 Bedrooms 2 Bathes Master with on Suite Updated in recent years Private Wash Room in Home . Rear Patio prefect for Parties and Family Gatherings. ', 0, 1, 1, 0, 0, 0, 'Unit at 225 E 57th St', '', 'New York', 41, '10022', '40.7600805', '-73.9664709\r', 1508463044, 1508463044, 4613, 703, 54, 5),
  228. (704, 1, 16, 'Condo/Co-op, 1 beds, 1.0 baths, 0 sq ft.', '', 0, 1, 1, 0, 0, 0, 'Unit at 305 E 88th St', '', 'New York', 41, '10128', '40.779053', '-73.949901\r', 1508463045, 1508463045, 4616, 704, 8, 2),
  229. (712, 1, 40, 'Townhouse, beds, baths, 0 sq ft.', 'You can own a 3 bedroom, single family home in downtown Orlando for $222,000. NEW roof in 2017! NEW Exterior paint in 2017! NEW Air Conditioner in 2016! Triple pane windows. Hardwood floors throughout. You can sit on the HUGE screened-in back porch and enjoy the corner lot that is adjacent to the highly desirable Lake Rowena neighborhood. This location is ideal. .. you can also walk to Audubon Park and the coffee shops, craft beer locations, weekly farmers market. ', 0, 0, 0, 0, 0, 0, '1876 W 8th St', '', 'Brooklyn', 41, '11223', '40.601394', '-73.9806909\r', 1508463050, 1508463050, 4666, 712, 54, 5),
  230. (734, 1, 29, 'Multi-Family (2-4 Unit), 9 beds, 4.0 baths, 2,844 sq ft.', 'Come view this completely renovated and unique multi-family property on a tree lined street. This astonishing 3 family house host a total of 9 bedrooms and 5 bathrooms. Master bedrooms have en suite bathrooms in 2 of the units. Equipped with stainless steel appliances and top of the line materials in each unit this house is truly in a league of its own. Must see, to appreciate the craftsmanship and details of this property! This home has a shared driveway that leads to garage in the rear of the house. This property has the potential to gross $73,200 in rental income. Take advantage of the market in The Bronx while you can! Completely Vacant and ready for its new owner. ', 1925, 9, 4, 0, 2844, 2735, '1024 E 225th St', '', 'Bronx', 41, '10466', '40.8845699', '-73.85114\r', 1508463063, 1508463063, 4803, 734, 8, 2),
  231. (740, 1, 1, 'Single Family Residential, 5 beds, 3.0 baths, 0 sq ft.', 'Beautiful Split In Desirable Section Of Lake Success. Features Master Br W/ Full Bth, 3 Brs And Full Bath On Upper Level, Lr/Dr And Eat-In-Kitchen On Main Level, Br, Full Bath, Family Room And 2 Car Garage On Lower Level And Finished Bsmt W/ Lots Of Storage. Close To Highways. Village Has 18 Hole Golf Course, Pool, Tennis & Police. Great Neck South Schools. ', 1961, 5, 3, 0, 0, 12075, '1 Lakeview Dr', '', 'Great Neck', 41, '11020', '40.761067', '-73.707998\r', 1508463066, 1508463066, 4833, 740, 8, 2),
  232. (743, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 0 sq ft.', '', 1950, 4, 3, 0, 0, 4800, '28-46 210th St', '', 'Bayside', 41, '11360', '40.774351', '-73.779691\r', 1508463068, 1508463068, 4848, 743, 8, 2),
  233. (747, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 0 sq ft.', 'Old Charm Colonial With 4 Bedrooms, 3 Bathrooms, Spacious Living Room And Formal Dining Room. East Exposure. Great Location. Close Proximity To Northern Blvd, Stores, Great Commute. 1 Car Garage. Finished Basement With Separate Entrance. ', 1920, 4, 3, 0, 0, 5000, '30-44 153rd St', '', 'Flushing', 41, '11354', '40.7702386', '-73.8114025\r', 1508463070, 1508463070, 4873, 747, 1, 1),
  234. (749, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 3,050 sq ft.', 'Public Remarks: Amazing Victoria/Colonial w/ 4 bdrms, 3 baths on tremendous 50 x 168 lot with inground heated pool. Roof, windows, siding replaced in 2013, wood floors, SS appliances, granite, full unfinished basement. 4th bedroom on private level with sitting area. 2 zone A/C; 3 zone heating; sprinkler system. BSMT; full unfinished w/ hi-ceiling; Level 1: large foyer w/ closet, FLR, FDR or huge family room, large kitchen w/ SS appliances, granite SGD to yard w/ inground heated pool and detached garage w/ new siding, new roof + Storage on top. Wood floors + gas fireplace; LEVEL 2: 3 Large bedrooms, Master w/ full bath LEVEL 3: Large bdrm w/ extra sitting area + Skylight ', 1901, 4, 3, 0, 3050, 8400, '121 Wood Ave', '', 'Staten Island', 41, '10307', '40.5142482', '-74.2450086\r', 1508463071, 1508463071, 4897, 749, 54, 5),
  235. (751, 1, 29, 'Multi-Family (2-4 Unit), 8 beds, 4.0 baths, 0 sq ft.', '', 1940, 8, 4, 0, 0, 1667, '452 Jefferson Ave', '', 'Brooklyn', 41, '11221', '40.6842754', '-73.9397978\r', 1508463072, 1508463072, 4902, 751, 8, 2),
  236. (756, 1, 29, 'Multi-Family (2-4 Unit), beds, baths, 0 sq ft.', 'Public Remarks: GORGEOUS LARGE SEMI-ATTACHED HOME IN EXCELLENT MOVE IN CONDITION. CONVENIENTLY LOCATED ON A BEAUTIFUL CUL-DE-SAC STREET CLOSE TO SCHOOLS, PARKS, GREAT KILLS MARINA, SHOPPING, AND TRANSPORTATION. FEATURING ALL BIG ROOMS, HARDWOOD FLOORS, CUSTOM HIGH-END BATH, HUGE KITCHEN, FULL FINISHED BASEMENT, GREAT PRIVATE YARD WITH POOL AND MUCH MORE! LEVEL 1: ENTRY FOYER, COAT CLOSET, LIVING ROOM, DINING ROOM, HALF BATH WITH LAUNDRY, KITCHEN, DINETTE WITH SLIDERS TO YARD. LEVEL 2: BEDROOM, BEDROOM, 3 PIECE FULL BATH. LEVEL 3: MASTER BEDROOM WITH DOUBLE CLOSETS. BASEMENT: FULL FINISHED, FAMILY ROOM, THREE QUARTER BATH, UTILITY, GARAGE. ', 0, 0, 0, 0, 0, 0, '943 E 80th St', '', 'Brooklyn', 41, '11217', '40.6815619', '-73.9785952\r', 1508463075, 1508463075, 4936, 756, 54, 5),
  237. (757, 1, 16, 'Condo/Co-op, 1 beds, 1.0 baths, 0 sq ft.', 'Beautiful Wooded Lot In Wedgefield Estates. Wedgefield, a Golf and Equestrian Community, Conveniently situated within 30 minutes of Downtown Orlando, I-95, Cocoa Beach, Orlando attractions, Orlando International Airport, UCF, and Lake Nona’s \'Medical City\'. ', 0, 1, 1, 0, 0, 0, 'Unit at 245 E 25th St', '', 'New York', 41, '10010', '40.7394879', '-73.9803273\r', 1508463075, 1508463075, 4939, 757, 8, 2),
  238. (761, 1, 16, 'Condo/Co-op, 2 beds, 1.75 baths, 1,076 sq ft.', 'TOP FLOOR 2 BEDROOM 1 ¾ BATH CO-OP APARTMENT IN PRIME BAY RIDE. FEATURES LIVING ROOM, DINING ROOM, EAT-IN KITCHEN, FULL BATH, 2 BEDROOMS (3/4 BATH IN MASTER), HARDWOOD FLOORS, STAINLESS STEEL APPLIANCES, GRANITE COUNTERTOPS, 17 FEET CEILINGS, 3 SKYLIGHTS, 3 DUCTLESS SPLIT UNIT HEATING AND COOLING. BRAND NEW WINDOWS AND BALCONY DOORS, COURTYARD, LAUNDRY ROOM IN BASEMENT. FRONT BALCONY: 25 SQ FT. REAR BALCONY: 78 SQ FT. PARKING AVAILABLE ON WAIT LIST. MONTHLY MAINTENANCE: $719.16 INCLUDES OTHER. SUBLET: YES. PETS: YES. MIN DP: 20%. FLIP TAX FEE: 1%. ', 0, 2, 2, 0, 1076, 0, '318 101 St Unit 40E', '', 'Brooklyn', 41, '11209', '40.6127838', '-74.0351936\r', 1508463078, 1508463078, 4970, 761, 8, 2),
  239. (764, 1, 1, 'Single Family Residential, 3 beds, 2.5 baths, 0 sq ft.', 'House . Located In North Flushing Area. Quite & Convenient. Det Lot Clonial 3Brs. 3Bath. Full Finished Basement. Det 2Car Garage. ', 1920, 3, 3, 0, 0, 4000, '33-42 163 St', '', 'Flushing', 41, '11358', '40.766673', '-73.802457\r', 1508463079, 1508463079, 4989, 764, 8, 2),
  240. (769, 1, 29, 'Multi-Family (2-4 Unit), 10 beds, 7.0 baths, 0 sq ft.', '2005 Newly Altered 4 Family With Big Extension. Each Floor Has More Than 1100 Sq. Ft Space, 3 Br, 2 Ba. Fully Finished High Ceiling Basement, Separate 5 Meters. Great Income Produce Property In High Demand Area. ', 2005, 10, 7, 0, 0, 1100, '35-09 105 St', '', 'Corona', 41, '11368', '40.754874', '-73.862917\r', 1508463081, 1508463081, 5020, 769, 8, 2),
  241. (778, 1, 16, 'Condo/Co-op, 0 beds, 1.0 baths, 0 sq ft.', 'Beautifully nestled and tastefully remodeled Northridge home located on a quiet Cul-de-Sac Street. The home boasts a bright, open, and light floorplan that perfectly complements the 3 bedroom and 3 bathroom space. Large backyard with fenced pool and spa perfect for entertainment. The home features tile roof, central air and heat upgraded copper plumbing with recirculating, new laminate flooring, remodeled bathrooms, kitchen and new interior paint throughout. Property located in the Highly Rated Nobel Middle school and Award Winning Granada High School District. ', 0, 0, 1, 0, 0, 0, 'Unit at 159 Madison Ave', '', 'New York', 41, '10016', '40.7465512', '-73.9835026\r', 1508463086, 1508463086, 5087, 778, 8, 2),
  242. (785, 1, 1, 'Single Family Residential, 3 beds, 1.0 baths, 1,600 sq ft.', 'Public Remarks: Presenting this Huge signle family home. Home is fully detached. Home needs TLC. Big lot of 4,400 sqft. Semi-Basement. CASH DEAL ONLY - Parking included. MOTIVATED SELLER AND HIGHLY CO-OPERATIVE LISTING AGENT! ', 1935, 3, 1, 0, 1600, 4400, '115 Roma Ave', '', 'Staten Island', 41, '10306', '40.5630684', '-74.1026334\r', 1508463090, 1508463090, 5144, 785, 8, 2);
  243. INSERT INTO `listings` (`id`, `owner_id`, `property_type`, `title`, `description`, `yearbuilt`, `beds`, `baths`, `sleeps`, `sqfeet`, `lotsize`, `address1`, `address2`, `city`, `state`, `zipcode`, `latitude`, `longitude`, `created`, `updated`, `id`, `listing_id`, `facility_id`, `category_id`) VALUES
  244. (786, 1, 29, 'Multi-Family (2-4 Unit), 7 beds, 3.5 baths, 1,242 sq ft.', 'PRIME OF BENSONHURST AREA, FULLY DETACHED VICTORIAN CORNER PROPERTY ON 40X100 LOT. POSSIBLE PRIVATE DRIVEWAY FOR LOTS OF CARS. GOOD FOR LARGE FAMILY. NEAR SHOPPING, TRANSPORTATION, AND SCHOOLS. OWNER WANTS TO HEAR ALL REASONABLE OFFERS ', 1925, 7, 4, 0, 1242, 4000, '2302 80 St', '', 'Brooklyn', 41, '11214', '40.6037109', '-73.988057\r', 1508463091, 1508463091, 5154, 786, 54, 5),
  245. (791, 1, 16, 'Condo/Co-op, 2 beds, 1.0 baths, 1,000 sq ft.', 'This Is A Fannie Mae Homepath Property. Fabulous 2 Bedroom Apt With Eat-In Kitchen On A High Floor. Offers Large Dining Room, Living Room, 2 Spacious Bedrooms And Bathroom. All Hardwood Floors. Low Maintenance Includes All Utilities. Located In A Well Maintained Building Near Trains And Shops, Parking Garage Blocks Away! ', 1951, 2, 1, 0, 1000, 0, '9609 67 Ave Unit 5D', '', 'Rego Park', 41, '11374', '40.72281', '-73.856756\r', 1508463094, 1508463094, 5180, 791, 8, 2),
  246. (794, 1, 1, 'Single Family Residential, 4 beds, 3.5 baths, 0 sq ft.', 'New Whitestone Development, The Bridges At Whitestone. Brick And Precast Stone Center Hall Colonials 4 Bedrooms, 3.5 Baths. Designed By Renowned Architect And Built By Award Winning Developer. High End Architectural Details Throughout, Hardwood Floors, Marble Entry, 9\'8\" Ceilings On 1st Fl And Cathedral On 2nd Fl. Close Proximity To Major Highways, Airports, Nyc ', 2015, 4, 4, 0, 0, 8036, '150-15 Sullivan Dr', '', 'Whitestone', 41, '11357', '40.7850656', '-73.8124984\r', 1508463095, 1508463095, 5199, 794, 54, 5),
  247. (797, 1, 1, 'Single Family Residential, 3 beds, 1.5 baths, 1,360 sq ft.', 'Beautiful semi - detached brick in the heart of Country Club! Upstairs boasts 3 spacious bedrooms, full bath and attic, step downstairs to a hallway 1/2 bath, spacious living room, separate dining room, renovated kitchen with granite countertops and tiled backsplash, beautiful hardwood floors thru out. Sliding doors off kitchen to custom made deck and also pool for entertaining. Semi finished basement with plenty of potential and one car garage and driveway complete this lovely home. ', 1960, 3, 2, 0, 1360, 2334, '3148 Valhalla Dr', '', 'Bronx', 41, '10465', '40.8404315', '-73.8230034\r', 1508463097, 1508463097, 5217, 797, 54, 5),
  248. (806, 1, 16, 'Condo/Co-op, 2 beds, 1.0 baths, 0 sq ft.', 'Property Sold \" As Is\" . Buyer To Verify All Information. Home Is Located On A Beautiful Block. House Is Close To Schools, House Of Worship, Shopping And Near Transportation. ', 0, 2, 1, 0, 0, 0, 'Unit at 720 Fort Washington Ave', '', 'New York', 41, '10040', '40.857835', '-73.9345111\r', 1508463105, 1508463105, 5261, 806, 8, 2),
  249. (808, 1, 1, 'Single Family Residential, 2 beds, 2.0 baths, 1,144 sq ft.', '', 1945, 2, 2, 0, 1144, 1240, '18 Center Pl', '', 'Staten Island', 41, '10306', '40.5633168', '-74.1009229\r', 1508463106, 1508463106, 5273, 808, 54, 5),
  250. (813, 1, 1, 'Single Family Residential, 3 beds, 1.5 baths, 1,020 sq ft.', 'This affordable single family home in Canarsie is back on the market and ready for its new owners! Featuring beautiful hardwood floors, spacious rooms as well as its own garage and private driveway which can park up to 5 cars. Conveniently located 1 block away from the L train and close proximity to P.S. 114 and I.S. 211 schools. Please bring your qualified buyers who are looking to act! ', 1925, 3, 2, 0, 1020, 2500, '654 E 105 St', '', 'Brooklyn', 41, '11236', '40.649311', '-73.897115\r', 1508463109, 1508463109, 5306, 813, 8, 2),
  251. (815, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 0 sq ft.', 'Super house in great location- all redone and in great condition. Nice layout all bedrooms upstairs. ', 0, 2, 2, 0, 0, 0, 'Unit at 205 E 78th St', '', 'New York', 41, '10075', '40.7735677', '-73.9574003\r', 1508463110, 1508463110, 5320, 815, 54, 5),
  252. (816, 1, 16, 'Condo/Co-op, 3 beds, 3.0 baths, 0 sq ft.', 'Beautiful townhome, 3 bed/2,5 baths, 1 car garage. Great Location, near to Lake Nona Medical City, conservation view. Nona Terrace is a quiet and quaint community that features the perfect lifestyle for young professionals and families with convenient access to all of the Orlando main arteries. Plenty of amenities: Basketball Court, Gated, Swimming Pool, Tennis Court, Tot Lot, Outdoor Fitness Area. ', 0, 3, 3, 0, 0, 0, 'Unit at 565 Park Ave', '', 'New York', 41, '10021', '40.7649462', '-73.9678635\r', 1508463110, 1508463110, 5327, 816, 54, 5),
  253. (825, 1, 1, 'Single Family Residential, 2 beds, 2.25 baths, 1,540 sq ft.', 'Sheepshead Bay/ Marine Park location First time on the market. One family brick home . ', 1930, 2, 2, 0, 1540, 1600, '2113 Gerritsen Ave', '', 'Brooklyn', 41, '11229', '40.603218', '-73.93624\r', 1508463114, 1508463114, 5382, 825, 1, 1),
  254. (826, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,872 sq ft.', 'Welcome to 4218 Gunther Avenue. Your New Single Family home is conveniently located in the Wakefield Section of the Bronx with mass transit ( trains and buses ) near by. Your home is Fully detached, offers a driveway, 3 Bedroom Duplex, 2 Full Bathrooms, Living Room, Family Room, Office Space, Dinning Room and Fully Finished Walk Out Basement. 4218 Gunther Avenue is situated on a quiet tree lined street with the ability to walk to shopping areas and places of worship. This home is available for you to own and enjoy this up-coming Holiday Season. Owner is motivated and home is easy to view. All offers will be entertained. ', 1920, 3, 2, 0, 1872, 0, '4218 Gunther Ave', '', 'Bronx', 41, '10466', '40.894605', '-73.849757\r', 1508463115, 1508463115, 5391, 826, 1, 1),
  255. (833, 1, 16, 'Condo/Co-op, 2 beds, 1.0 baths, 790 sq ft.', '', 1960, 2, 1, 0, 790, 0, '51 st 51 St Unit 39-35', '', 'call Listing Agent', 41, '11377', '40.7474918', '-73.913059\r', 1508463118, 1508463118, 5431, 833, 8, 2),
  256. (839, 1, 1, 'Single Family Residential, 3 beds, 1.5 baths, 1,764 sq ft.', 'This Home Will Prove To Be A Haven For The Owner Seeking Quality, Comfort & Convenience. The Owens Family Have Shared Some Of Their Most Cherished Moments Here & Are Ready To Pass This Opportunity To The Next Owner Excited To Create New Ones. Offering Generous Entertainment Space Throughout; You\'ll Be Right At Home In The Warmth Of The Fireplace Through The Winter. ', 1935, 3, 2, 0, 1764, 3000, '116-23 204th St', '', 'Jamaica', 41, '11412', '40.696301', '-73.748704\r', 1508463121, 1508463121, 5475, 839, 54, 5),
  257. (853, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,120 sq ft.', 'New heater and hot water tank, no HOA fee, no flood insurance needed. Semi detached house with lots of natural light. S79 bus stop on Hylan Blvd just in few minutes away. ', 1988, 3, 2, 0, 1120, 2400, '300 Alter Ave Unit A', '', 'State Island', 41, '10305', '40.5886769', '-74.09128\r', 1508463128, 1508463128, 5548, 853, 1, 1),
  258. (854, 1, 16, 'Condo/Co-op, 1 beds, 1.0 baths, 0 sq ft.', 'Spacious L Shaped 1 Bedroom With Terrace, Conveniently Located Off Union Tple. Close To Shopping And Transportation. This Unit Is Offered In Its As Is Condition! ', 1950, 1, 1, 0, 0, 0, '150-15 79 Ave Unit 6F', '', 'Kew Garden Hills', 41, '11367', '40.720345', '-73.812853\r', 1508463128, 1508463128, 5555, 854, 54, 5),
  259. (856, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 1,200 sq ft.', 'Top Floor: 2 Bedrooms/ 2 Baths Coop in amazing condition w/loft, 2 terraces & Bridge View from both bedrooms. New kitchen and baths, cathedral ceilings. Both bedrooms king sized with a loft in the Master Bedroom. 5 large closets. Storage closet, laundry & bike room in the basement. Kitchen has SS Appliances, wine fridge, granite counters. New HWH, New HW Floors, New Bathroom Skylights, New PTAC units. An amazing home! Maint of $719 includes RE Taxes, water & building Expenses. 3 Skylights. Parking available (via waiting list) near by. Common garden area available for all share holders. ', 1981, 2, 2, 0, 1200, 0, '312 101 St Unit 42E', '', 'Brooklyn', 41, '11209', '40.6128458', '-74.035321\r', 1508463129, 1508463129, 5565, 856, 8, 2),
  260. (857, 1, 40, 'Townhouse, beds, baths, 0 sq ft.', 'Excellent And Well Maintained Ranch House With Half Finished Basement. Very Close To Transportation. Formal Dining Room With An Excellent And Kitchen. ', 0, 0, 0, 0, 0, 0, '208 42nd St', '', 'Brooklyn', 41, '11232', '40.653211', '-74.012184\r', 1508463130, 1508463130, 5579, 857, 54, 5),
  261. (861, 1, 16, 'Condo/Co-op, 4 beds, 2.5 baths, 0 sq ft.', 'Cute 1 Family Home With Driveway, Nice Block ', 1960, 4, 3, 0, 0, 2250, '639 Beach 65th St', '', 'Far Rockaway', 41, '11691', '40.5982246', '-73.7950134\r', 1508463131, 1508463131, 5597, 861, 8, 2),
  262. (864, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 0 sq ft.', 'Desirable Brick Ranch In Oakland Gardens, Near To Alley Pond Park, School Dist. #26, P. S. #188, Less Than 10 Yrs Of Window Electricity 220 Amp Upgrade, Central Air/Heating, Full Finished High Ceiling Nice & Dry Huge Basement With Separate Entrance, Bus To Flushing, Sun Drenched South Faced Bay Window, Separate Steps To Front And Side Entrance, Large Nice Backyard W/ Shed, ', 1960, 3, 2, 0, 0, 4300, '224-67 77th Ave', '', 'Bayside', 41, '11364', '40.739121', '-73.7464\r', 1508463133, 1508463133, 5617, 864, 8, 2),
  263. (866, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 796 sq ft.', '', 2016, 2, 2, 0, 796, 0, '71-59 160 St Unit 3A', '', 'Flushing', 41, '11355', '40.7710915', '-73.8044128\r', 1508463134, 1508463134, 5630, 866, 54, 5),
  264. (868, 1, 1, 'Single Family Residential, 4 beds, 4.0 baths, 1,740 sq ft.', 'Public Remarks: COMPLETELY RENOVATED AND UPDATED COLONIAL IN SUNSET HILL. SUNSET HILL BUILDERS PROVIDE QUALITY WORKMANSHIP AND ATTENTION TO DETAIL. EVERYTHING IS NEW. PLUMBING, ELECTRIC, KITCHEN, HARDWOOD FLOORS, SIDING, INSULATION, WINDOWS. 4 BATHS, 4 BEDROOMS, PRIVATE BACKYARD, STAINLESS STEEL APPLIANCES, 4 ZONE HEAT, WOOD BURNING FIREPLACE, CENTRAL AIR. THIS HOME OFFERS THE BEST OF OLD WORLD CHARM WITH UPDATED MECHANICALS & INFRASTRUCTURE. ', 1901, 4, 4, 0, 1740, 4400, '352 Hart Ave', '', 'Staten Island', 41, '10310', '40.6251172', '-74.1058102\r', 1508463135, 1508463135, 5639, 868, 8, 2),
  265. (877, 1, 1, 'Single Family Residential, 3 beds, 2.5 baths, 0 sq ft.', 'Three Bedroom, Living Room, Dining Room, Kitchen, 2.5 Bath, Full Finished Basement With Separate Entrance. ', 1960, 3, 3, 0, 0, 3650, '111-26 Sutphin Blvd', '', 'Jamaica', 41, '11435', '40.68779', '-73.795444\r', 1508463139, 1508463139, 5697, 877, 8, 2),
  266. (878, 1, 16, 'Condo/Co-op, 3 beds, 2.5 baths, 2,039 sq ft.', 'Triplex, Breathtaking Waterfront Views, Wood Flooring, Community Park. Central A/C, 2 And Half Bath. 2050 Sqft Of Living Space. Garage And Driveway And Back Yard. ', 1989, 3, 3, 0, 2039, 0, '120-12 Riviera Ct Unit 20A', '', 'College Point', 41, '11356', '40.7949325', '-73.8474862\r', 1508463140, 1508463140, 5714, 878, 54, 5),
  267. (879, 1, 1, 'Single Family Residential, 4 beds, 3.5 baths, 2,223 sq ft.', 'Built in 2014, this Side Hall Colonial Home features 4 Bdrms, 3.5 Baths with Private Driveway & Garage. Nestled on a quiet block on a 50x100 Lot. ', 2014, 4, 4, 0, 2223, 3750, '292 Loretto St', '', 'Staten Island', 41, '10307', '40.5035464', '-74.2395561\r', 1508463141, 1508463141, 5715, 879, 1, 1),
  268. (880, 1, 29, 'Multi-Family (2-4 Unit), 8 beds, 5.0 baths, 0 sq ft.', 'New Construction 2 Family Detached Featuring 8 Bedrooms, 5 Full Baths Full Finished Basement, 2 Boiler And 2 Hot Water Tanks, Hardwood Floors Tru Out, Stainless Steel Appliances, Granite Counter Tops , Wide Pvt Driveway , Separate Entrance To Each Floor All This And Much More Sitting On A 50X100 Lot , Close To All Major Hwys And Shopping Malls. ', 2017, 8, 5, 0, 0, 5000, '142-18 254th St', '', 'Rosedale', 41, '11422', '40.6593779', '-73.733354\r', 1508463141, 1508463141, 5722, 880, 54, 5),
  269. (882, 1, 1, 'Single Family Residential, 6 beds, 7.0 baths, 6,522 sq ft.', 'Beautiful Home In The Desired Neighborhood Of Bayside Gables. You Will Love This Home With Excellent Condition. This Amazing Home Offers 6 Bedrooms And 7 Baths With Pool & Elevator. It Was Renovated And Extended Out In 2008 With High End Appliances And Materials. Approx 2,000 S. F Added . Owner Payed Over Than $700,000 Dollars For Renovation. Total Size:6522 Sf ', 1940, 6, 7, 0, 6522, 11480, '216-20 27th Ave', '', 'Bayside', 41, '11360', '40.779413', '-73.770717\r', 1508463142, 1508463142, 5742, 882, 54, 5),
  270. (887, 1, 29, 'Multi-Family (2-4 Unit), beds, 2.0 baths, 0 sq ft.', 'Welcome to 2177 East 35th Street, this is the 1st sale in the history of this home. This is a legal two family semi-detached brick high ranch. The building stretches 22 feet wide and a massive 53 feet deep. This house has been in the same family since it was built. The house is configured as a top floor three and one bath and the bottom floor is a very large two bedroom and 1 bath. Both apartments have eat in kitchens and nice sized living rooms. The boiler is brand new and the roof is around 10 years old. The house is dated and does need a cosmetic renovation. There are parking spots for three cars, this includes a one car garage and two cars in the driveway. There is a nice sized backyard also as well as front yard. This is one of Marine Parks best and most convenient blocks. It is fully tree lined, the B3 is literally on the corner, this can take you to E 16th and Avenue U to the B or Q train. The shopping of Avenue S is two blocks away. Marine Park itself is less than 2 blocks away and the Nature preserve is across the street. This home will produce very good rental income on either floor, this will offset your mortgage cost tremendously. The sellers are motivated and want to hear all reasonable offers. Delivered vacant. ', 0, 0, 2, 0, 0, 2600, '2177 E 35 St', '', 'Brooklyn', 41, '11234', '40.606338', '-73.928444\r', 1508463145, 1508463145, 5771, 887, 8, 2),
  271. (891, 1, 29, 'Multi-Family (2-4 Unit), beds, baths, 0 sq ft.', 'BEAUTIFUL HOME 3 BEDROOMS AND TWO BATHROOMS LOCATED IN GREENPOINTE SUBDIVISION. AN SMALL COMMUNITY WITH ACCESS TO MAJOR HIGHWAYS , THEME PARKS, RESTAURANTS , SUPERMARKETS LIKE PUBLIX, PHARMACY AND GROCERY STORES. SPLIT LEVEL, VAULTED CEILINGS WITH CERAMIC TILE AND LAMINATE FLOORS. GREAT SCREENED POOL WITH A NEW MOTOR PUMP AND DIAMOND BRIGTH REFACED TO RELAX IN A CONSERVATION VIEW. BRIGHT NEW APPLIANCES. NEW DISPOSAL AND UPDATED MASTER BATHROOM AS COMPLETE WITH SHOWER DOORS. FRESH PAINTED HOME INSIDE AND OUTSIDE. BEAUTIFUL GARDEN AND LAWN TO ENJOY THE NATURE. GREAT OPPORTUNITY FOR A FIRST TIME BUYER WITH A COMFORTABLE PAYMENT. THE COMMUNITY OFFERS A CLUB HOUSE AND A POOL TO ENJOY WITH YOUR FAMILY AND FRIENDS. ', 0, 0, 0, 0, 0, 0, '1816 Sterling Pl', '', 'Brooklyn', 41, '11233', '40.6706703', '-73.9184641\r', 1508463147, 1508463147, 5803, 891, 54, 5),
  272. (902, 1, 1, 'Single Family Residential, 3 beds, 2.5 baths, 0 sq ft.', 'Fully Renovated Semi Attached Home With 2,000 Square Feet Of Living Space. Top Floor Has 3 Br\'s, 1 Full Bath With All Brand New Closets And A Full Pull Down Attic For Storage. The Middle Level Has An Open Layout, Brand New Kitchen With Center Island, Marble Counters, Sub Zero And Sliders Leading Out To A Top Deck With Gas Weber Bbq Grill. Walk In Is A Large Room With Bath. ', 1970, 3, 3, 0, 0, 2500, '145-15 Neponsit Ave', '', 'Neponsit', 41, '11694', '40.571336', '-73.861874\r', 1508463152, 1508463152, 5875, 902, 54, 5),
  273. (907, 1, 1, 'Single Family Residential, 3 beds, 3.0 baths, 2,000 sq ft.', 'Public Remarks: GORGEOUS LARGE SEMI-ATTACHED HOME IN EXCELLENT MOVE IN CONDITION. CONVENIENTLY LOCATED ON A BEAUTIFUL CUL-DE-SAC STREET CLOSE TO SCHOOLS, PARKS, GREAT KILLS MARINA, SHOPPING, AND TRANSPORTATION. FEATURING ALL BIG ROOMS, HARDWOOD FLOORS, CUSTOM HIGH-END BATH, HUGE KITCHEN, FULL FINISHED BASEMENT, GREAT PRIVATE YARD WITH POOL AND MUCH MORE! LEVEL 1: ENTRY FOYER, COAT CLOSET, LIVING ROOM, DINING ROOM, HALF BATH WITH LAUNDRY, KITCHEN, DINETTE WITH SLIDERS TO YARD. LEVEL 2: BEDROOM, BEDROOM, 3 PIECE FULL BATH. LEVEL 3: MASTER BEDROOM WITH DOUBLE CLOSETS. BASEMENT: FULL FINISHED, FAMILY ROOM, THREE QUARTER BATH, UTILITY, GARAGE. ', 1999, 3, 3, 0, 2000, 3450, '226 Doane Ave', '', 'Staten Island', 41, '10308', '40.55502', '-74.155382\r', 1508463155, 1508463155, 5911, 907, 54, 5),
  274. (909, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 0 sq ft.', 'Fannie Mae Homepath Property. One Bedroom, One Bathroom Co-Op Unit Located In Holliswood. Complex Is Well Maintained And Unit Has Been Updated And Features New Tile Flooring In Kitchen And Bathroom, New Cabinets In Kitchen With Ss Appliances, And New Carpet Throughout The Unit. ', 0, 2, 2, 0, 0, 0, 'Unit at 465 W End Ave', '', 'New York', 41, '10024', '40.7865988', '-73.979897\r', 1508463156, 1508463156, 5919, 909, 8, 2),
  275. (916, 1, 29, 'Multi-Family (2-4 Unit), 3 beds, 2.5 baths, 1,728 sq ft.', 'Location! Location! 2 Family Brick, Reverse Duplex + 3 rooms rental apartment. Near Kings Highway N train and shopping. Possible full possession, Must See! Won\'t Last. ', 1930, 3, 3, 0, 1728, 1064, '1858 W 7 St', '', 'Brooklyn', 41, '11223', '40.6019155', '-73.9797267\r', 1508463162, 1508463162, 5972, 916, 54, 5),
  276. (926, 1, 29, 'Multi-Family (2-4 Unit), 2 beds, 2.0 baths, 1,083 sq ft.', 'It\'s a beautiful detach multi-family home in Arrochar. 2 family converted from 1 family. 44x26 building on a 50x40 lot size. Year built in 1925. Good neighborhood that few blocks away from the beach and close to few eatery spots. Highly motivated seller and very cooperative listing agent!!! ', 1925, 2, 2, 0, 1083, 2000, '75 Ocean Ave', '', 'Staten Island', 41, '10305', '40.596705', '-74.0635097\r', 1508463171, 1508463171, 6017, 926, 8, 2),
  277. (929, 1, 1, 'Single Family Residential, 2 beds, 2.0 baths, 1,000 sq ft.', 'Public Remarks: Water Front!! Totally renovated end unit townhouse with sweeping ocean views. New wood floors throughout plus fully tiled full bath. Staircase to Attic with lots of storage. Affordable and one-of-a-kind townhome. ', 1988, 2, 2, 0, 1000, 900, '446 Sprague Ave', '', 'Staten Island', 41, '10307', '40.5005076', '-74.236716\r', 1508463173, 1508463173, 6038, 929, 1, 1),
  278. (931, 1, 40, 'Townhouse, 3 beds, 3.0 baths, 1,504 sq ft.', 'Public Remarks: TOTALLY REDONE 2 FAMILY SEMI IS MOVE IN READY!! 3 BEDROOM MASTER AND ONE BEDROOM RENTAL. SEPARATE HEAT AND HOT WATER. BRAND NEW KITCHEN-STAINLESS, GRANITE AND TILE HARDWOOD THROUGHOUT, CROWN MOULDING, BASEBOARD HOT WATER HEAT, CENTRAL AIR. BASEMENT:LAUNDRY ROOM, UTILITY ROOM. LEVEL 1: ENTRY FOYER, LIVING/DINING ROOM COMBO, EAT IN KITCHEN, FAMILY ROOM WITH GAS FIREPLACE AND SLIDERS TO DECK AND YARD, 1/2 BATH. LEVEL 2:MASTER BEDROOM SUITE WITH FULL 4 PIECE BATH AND JETTED TUB, BEDROOM, BEDROOM, FULL BATH. ATTIC STORAGE. ', 2005, 3, 3, 0, 1504, 2680, '36 Santa Monica Ln', '', 'Staten Island', 41, '10309', '40.537576', '-74.212814\r', 1508463174, 1508463174, 6055, 931, 54, 5),
  279. (932, 1, 40, 'Townhouse, 3 beds, 1.5 baths, 0 sq ft.', 'Beautifully Renovated One Family Semi-Detached House In Bensonhurst. This Sun-Filled Home Features Ceramic Tiled Floors On The First Floor With An Open Layout Where The Living Room Seamlessly Flows Into The Dining Room & New Kitchen. The Renovations Include Quartz Countertops, Subway Tile Backsplash & Lg Stainless Steel Appliances. .(Cont\'d) ', 1930, 3, 2, 0, 0, 2000, '7105 21st Ave', '', 'Brooklyn', 41, '11204', '40.6114976', '-73.9871617\r', 1508463175, 1508463175, 6058, 932, 8, 2),
  280. (934, 1, 1, 'Single Family Residential, 4 beds, 2.0 baths, 1,680 sq ft.', 'Public Remarks: Raised ranch (25x46 on irregular corner lot) in Willowbrook features 4 bedrooms, 2 bathrooms, kitchen with dinette, living room, dining room, office/den, built-in garage and backyard with deck. ', 1970, 4, 2, 0, 1680, 4800, '86 Sunset Ave', '', 'Staten Island', 41, '10314', '40.600493', '-74.13387\r', 1508463176, 1508463176, 6071, 934, 8, 2),
  281. (939, 1, 16, 'Condo/Co-op, 1 beds, 1.0 baths, 0 sq ft.', 'Semi Detached1 Family Home Featuring 3 Bedrooms, Full Finished Basement, 1 Car Garage. ', 0, 1, 1, 0, 0, 0, 'Unit at 264 W 22nd St', '', 'New York', 41, '10011', '40.7442415', '-73.9985766\r', 1508463179, 1508463179, 6105, 939, 54, 5),
  282. (947, 1, 16, 'Condo/Co-op, 3 beds, 1.75 baths, 1,200 sq ft.', 'Tastefully designed and fully custom built Duplex penthouse of over 1200 sq. ft. of interior space in addition to an 800 sq. ft. private terrace. 3 bedrooms and 2 bathroom (on two level) of top of the line Italian finishes, expensive fixtures, modern kitchen with stainless steel appliances, top grade granite counters and bar. All custom amazing wall to wall closets in each bedroom. Nice Balcony from Living Room. Build in Washer and Drier Machine. Hardwood floor. Gorgeous Private Terrace (over 800 Sq.Feet for your enjoyment all year around) Walk in Closets, Storage in basement, Large and Private parking spot. Tax abatement for another 5 years. Building convenience located to the Public Transportation -D-train (Bay 50th Street Station) - 3 minutes walk, Buses, Belt Parkway and shopping. ', 2007, 3, 2, 0, 1200, 0, '2578 W 16 St Unit 3B', '', 'Brooklyn', 41, '11214', '40.584861', '-73.9851141\r', 1508463183, 1508463183, 6153, 947, 8, 2),
  283. (949, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 0 sq ft.', 'Luxury Living- 2 Bedrooms, 2 Baths, Open Kitchen, Renovated. . Move In Condition Immaculate Lg. Terrace, Taxes, ,Gas & Elec Included In Maint. Amenities 24 Hr Doorman, Restaurant/Deli/Grocery Store. ,Dry Cleaners, Beauty Spa, ,Pool, Health Club , Tennis. Priced To Sell. Total Monthly Outlay = $1,300.75 & $149 Parking. ', 1970, 2, 2, 0, 0, 0, '18-05 215 St Unit 3 F', '', 'Bayside', 41, '11360', '40.7845412', '-73.7767724\r', 1508463184, 1508463184, 6170, 949, 54, 5),
  284. (958, 1, 1, 'Single Family Residential, 3 beds, 1.5 baths, 1,300 sq ft.', 'We Are Proud to Present This New Listing in Highly Desirable, Prime Borough Park Location! This Lovely Detached Home is Situated Atop a Hill on a Quiet Residential Block. Tremendous Potential to Turn It Into Your Dream Home! Great Curb Appeal with Front Yard and Garden, New Granite Front Stoop and Railings. House Also Has Front and Rear Porches. Nice Secluded Backyard. Walking Distance from Train, Parks, Maimonides Hospital and Houses of Worship. Sold in \"As-Is\" Condition. R5 Zoning, Buildable 1,241 sq.ft. More. Motivated Sellers Want to Hear All Serious pre-Qualified Offers. ', 1925, 3, 2, 0, 1300, 2003, '1063 56 St', '', 'Brooklyn', 41, '11219', '40.63429', '-74.000996\r', 1508463189, 1508463189, 6212, 958, 8, 2),
  285. (961, 1, 1, 'Single Family Residential, 3 beds, 2.0 baths, 1,218 sq ft.', 'Beautiful, Move In Ready - 3 Bedroom, 2 Bath, Brick Cape Located In Lakeville Estates. Renovated Eat-In Kitchen With Granite Countertops, Stainless Steel Appliances. Updated Baths, New Roof, Siding, Gutters, Hot Water Heater, Boiler. Wood Floors Throughout, Sprinkler System. Close To All. ', 1946, 3, 2, 0, 1218, 4200, '27 79th Ave', '', 'New Hyde Park', 41, '11040', '40.7493756', '-73.7000848\r', 1508463191, 1508463191, 6238, 961, 54, 5),
  286. (963, 1, 16, 'Condo/Co-op, 2 beds, 1.5 baths, 0 sq ft.', 'GREAT OPPORTUNITY FOR FIRST TIME BUYERS, OR GREAT INVESTMENT PROPERTY. LOCATION IS GREAT CLOSE TO ALL MAYOR HIGHWAYS. NICE AND BIG BACKYARD. WONDERFUL SCHOOLS IN THE AREA. EAT IN KITCHEN AREA AND SPACIOUS ROOMS. ', 0, 2, 2, 0, 0, 0, 'Unit at 125 E 93rd St', '', 'New York', 41, '10128', '40.784343', '-73.952713\r', 1508463192, 1508463192, 6249, 963, 54, 5),
  287. (964, 1, 1, 'Single Family Residential, 3 beds, 1.5 baths, 1,344 sq ft.', 'This one family 3 bedroom, 2.5 bath is in the heart of East Flatbush. Close to lots of stores, park and walking distance to train(2,5). This is definitely one you want to see. Schedule viewing today... ', 1925, 3, 2, 0, 1344, 1950, '3711 Foster Ave', '', 'Brooklyn', 41, '11203', '40.639239', '-73.941129\r', 1508463192, 1508463192, 6254, 964, 54, 5),
  288. (985, 1, 16, 'Condo/Co-op, 2 beds, 1.5 baths, 786 sq ft.', '', 1925, 2, 2, 0, 786, 1350, '118-26 154th St', '', 'Jamaica', 41, '11434', '40.6804119', '-73.788703\r', 1508463203, 1508463203, 6401, 985, 54, 5),
  289. (991, 1, 16, 'Condo/Co-op, 2 beds, 2.0 baths, 0 sq ft.', 'Unique opportunity, newer built & luxurious 2-story home. Tucked away in serene area with valley views. Drought tolerant landscaping & custom stone walkway add to curb appeal. High ceilings & French doors throughout. Living, family, & dining rooms. Elegant double-sided fireplace. Open & upgraded kitchen with granite counters, center island/breakfast bar, newer range, dishwasher, eating area, & walk-in pantry. Convenient guest bath. Laundry room. Multiple balconies upstairs overlook backyard. Spacious master suite boasts fireplace, walk-in closet, & private bath featuring impressive shower w/ dual shower heads & separate spa tub. Second master suite at other side also has private bath w/ shower & separate spa tub. Third bedroom w/ 2 closets. Hall bath w/ shower. Additional features include upgraded baths, tile, wood, & carpet flooring, dual A/C, fresh interior paint, recessed lights, & newer water heater. Direct access to oversized 2-car garage w/ storage space. Long driveway for possible RV parking. Nature surrounds you in the backyard. Open space & mountain views. Private road with newer custom-built million dollar properties in the neighborhood. Enjoy the away from city feeling, yet close to freeway access. Must see! ', 0, 2, 2, 0, 0, 0, 'Unit at 1015 Eighth Ave', '', 'Brooklyn', 41, '11215', '40.664655', '-73.979771\r', 1508463207, 1508463207, 6440, 991, 8, 2),
  290. (992, 1, 29, 'Multi-Family (2-4 Unit), 4 beds, 4.0 baths, 0 sq ft.', 'Investors/Builders Dream Lot! 3 Family House Sitting On An Extra Large Lot 60X100. Far Residential . 60 Up To 3600 Sf Buildable. Up To 6,000 Sf Facility Buildable Based On Far 1, (Please Check With Your Local Architect). All Information Is Deemed Accurate But Not Guaranteed! ', 1940, 4, 4, 0, 0, 6000, '83-15 169th St', '', 'Jamaica', 41, '11432', '40.717152', '-73.795938\r', 1508463207, 1508463207, 6446, 992, 8, 2),
  291. (993, 1, 40, 'Townhouse, 5 beds, 3.0 baths, 2,187 sq ft.', 'Public Remarks: HI RANCH 6 OVER 5, 3 BEDROOM MASTER, 2 BEDROOM RENTAL. BOTH APARTMENTS IN EXCELLENT CONDITION. SPACIOUS MANICURED REAR YARD, 1 CAR BUILTIN GARAGE, FULL FINISHABLE BASEMENT WITH ACCESS TO REAR YARD AND ACCESSIBLE FROM MASTER UNIT. 2 DRIVEWAYS. 1 LAYER ROOF ABOUT 15 YEARS OLD. 2 GAS FA HEATING UNITS, 2 GHW TANKS, 2 ELECTRIC SERVICES . NEWER VINYL WINDOWS + GLEAMING OAK FLOORS THROUGHOUT. 2ND FL: L SHAPE LR/FDR, EIK, MBR W/ 3/4 BATH, BR, BR, FULL BATH, 4 IN WALL NEW AC UNITS, ACCESS TO BSMT. + GARAGE. BSMT: UNFIN HIGH CEILINGS, FRAMED AND READY TO FINISH, ROUGHING FOR 3/4 BATH, SLGD TO REAR YARD. 1st FL: 4 ROOM 2 BR APT. IN EXCELLENT CONDITION TOTALLY RENOVATED 10 YEARS AGO. FLOOD INS. REQUIRED FOR MORTGAGE. NEW GARAGE DOOR, 43 X 112.5 LOT, BIG REAR YARD, SUBJECT TO ERRORS AND OMISSIONS ', 1970, 5, 3, 0, 2187, 4725, '100 Slater Blvd', '', 'Staten Island', 41, '10305', '40.5817995', '-74.0924058\r', 1508463208, 1508463208, 6457, 993, 8, 2),
  292. (999, 1, 1, 'Single Family Residential, 3 beds, 3.0 baths, 1,210 sq ft.', 'Public Remarks: Beautiful 3 bedroom, 3 bath in the most desireable area. Just minutes from the Verrazano Bridge. This house offers Living room/dining room combo, eat in kitchen with sliding glass doors to the yard. 3 nice size bedrooms and finished basement. Brand new water tank. ', 1999, 3, 3, 0, 1210, 1886, '48 Garden St', '', 'Staten Island', 41, '10314', '40.6112602', '-74.1239122\r', 1508463211, 1508463211, 6495, 999, 54, 5),
  293. (1001, 1, 16, 'Condo/Co-op, 3 beds, 3.0 baths, 0 sq ft.', 'Centrally Located In The Heart Of The Valley, This Fully Updated Modern POOL Home Has All The Bells And Whistles. Welcoming You in through the Lighted Modern Front Door, This Wide Open Floor Plan Boasts a Spacious Kitchen Setting the Standard with a Custom 9-Foot Island Bar with White Marble Callacatta Countertops, Pendant Lighting, and Built-In Appliances. This 4 Bed 3 Bath Home Has Ample Parking Space for your RV Or Boat, and 2 Car Garage With Attached Bonus Utility/Storage Room with Door and Window. Here You Will Find a Tastefully Designed Marble Fireplace Surrounded by Large windows and Glass Sliding Door Providing Ample Natural Lighting and a Breathtaking View of the Pool and Firepit. The Large Enclosed Yard is Great For Entertaining Guests. The Master Suite Has a Walk In Closet, and a Private Stone Bathroom. This Home Features Wood Floors Throughout, Recessed Lighting, High-End Stainless Steel Kitchen Appliances, Central Air Conditioning and Heat with Wi-Fi Nest Thermostat, Pool Has New Plaster Plenty of Storage Space, and a Cozy Stone Covered Patio Area. First Time Home Buyers and Those Looking to Accommodate Their Growing Family Will Appreciate Being Close to Some of the Best Schools in the Valley. ', 0, 3, 3, 0, 0, 0, 'Unit at 211 Schermerhorn St', '', 'Brooklyn', 41, '11201', '40.688986', '-73.985399\r', 1508463212, 1508463212, 6502, 1001, 8, 2),
  294. (1002, 1, 1, 'Single Family Residential, 3 beds, 4.0 baths, 1,750 sq ft.', 'Public Remarks: OCCUPIED WITH NO ACCESS!! Available for sale semi-detached one family townhouse house being sold in its \'\'as is\'\' condition OCCUPIED. Interior inspections are not available. Property features 5 rooms, kitchen, 3 bedrooms, 3.5 baths, lots of closets, full finished basement, deck and carport. Conveniently situated close to schools, day care, shopping, house of worship and transportation. Property will NOT be delivered vacant. Please do not disturb occupants at any time. ', 2005, 3, 4, 0, 1750, 1776, '32 Rumpler Ct', '', 'Staten Island', 41, '10302', '40.625476', '-74.142377\r', 1508463212, 1508463212, 6510, 1002, 1, 1),
  295. (1009, 1, 16, 'Condo/Co-op, 2 beds, 1.0 baths, 0 sq ft.', 'Beautiful Large 2 Bedroom With Large Dining Area Lower Unit. Desirable Location, District 26 Schools, Close To Shopping And Transportation. ', 1955, 2, 1, 0, 0, 0, '225-04 Stronghurst Ave #2414', '', 'Queens Village', 41, '11427', '40.732686', '-73.743865\r', 1508463216, 1508463216, 6559, 1009, 54, 5),
  296. (1012, 1, 16, 'Condo/Co-op, 1 beds, 1.0 baths, 0 sq ft.', 'Fannie Mae Homepath Property. One Bedroom, One Bathroom Co-Op Unit Located In Holliswood. Complex Is Well Maintained And Unit Has Been Updated And Features New Tile Flooring In Kitchen And Bathroom, New Cabinets In Kitchen With Ss Appliances, And New Carpet Throughout The Unit. ', 1950, 1, 1, 0, 0, 0, '198-44 Pompeii Ave Unit 1 A', '', 'Hollis', 41, '11423', '40.7212817', '-73.7651343\r', 1508463217, 1508463217, 6575, 1012, 8, 2),
  297. (1016, 1, 1, 'Single Family Residential, 4 beds, 3.0 baths, 1,679 sq ft.', 'Public Remarks: Four bedroom end unit Town Home! Featuring newer kitchen and three bathrooms, hardwood floors, one car garage. Low maintenance fees with include two pools, tennis and basketball courts, outside maintenance and snow removal. Near shopping and transportation, a perfect home for a young family. ', 1996, 4, 3, 0, 1679, 560, '486 Ilyssa Way', '', 'Staten Island', 41, '10312', '40.560602', '-74.187029\r', 1508463219, 1508463219, 6607, 1016, 1, 1),
  298. (1018, 1, 16, 'Condo/Co-op, 3 beds, 3.5 baths, 0 sq ft.', 'Excellent opportunity to purchase a place of your own in beautiful Sherman Oaks! This spacious condo is centrally located with only a short walk or bike ride away from Ventura Blvd. which features excellent shopping, entertainment and trendy dining. The open floor plan of this 2 bedroom 2 bath home flows smoothly from the dining area into the step down living room. The smartly designed galley style kitchen features an abundance of maple cabinets for lots of storage. The double sink and beautiful granite counter tops make for easy entertaining. ,Included in the sale is the range, microwave, built-in dishwasher and refrigerator. A private balcony is perfect for relaxing with a cup of coffee or glass of wine which lies just off the living area with a lovely view of the trees. Both roomy bedrooms provide a welcoming atmosphere with ample closet space and expansive windows. There is a community pool for those hot summer day! This unit features 2 parking places in the secure garage with lots of storage! ', 0, 3, 4, 0, 0, 0, 'Unit at 252 E 57th St', '', 'New York', 41, '10022', '40.7596122', '-73.9660556\r', 1508463220, 1508463220, 6623, 1018, 54, 5),
  299. (1029, 1, 29, 'Multi-Family (2-4 Unit), 4 beds, 2.0 baths, 0 sq ft.', 'Legal 2 Family With 4 Bedrooms, Plus Basement. Priced To Sell For Investors And Cash Buyers. Property Needs To Be Renovated. Includes Approved Plans And Permits. Serious Cash Buyers Only! Must Have Proof Of Funds. ', 1931, 4, 2, 0, 0, 1667, '751A Monroe St', '', 'Brooklyn', 41, '11221', '40.6884264', '-73.9266043\r', 1508463225, 1508463225, 6692, 1029, 8, 2);
  300.  
  301. ALTER TABLE `listings` ADD PRIMARY KEY (`id`);
  302. ALTER TABLE `listings` MODIFY `id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1038;COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!