15605 Indian Queen DRIVE, Odessa, FL, 33556 | $675,000

Under contract-accepting backup offers. Experience the perfect blend of modern luxury and established charm in this beautifully updated home in Farmington Village. COMPLETELY REMODELED two years ago, this home boasts a TWO YEAR OLD ROOF and pristine landscaping that enhances its curb appeal. The kitchen is a chef’s dream, featuring an HUGE ISLAND with stunning QUARTZ countertops, top-of-the-line stainless steel appliances, including a WINE FRIDGE and a range with an AIR FRYER setting. The home’s light-filled OPEN FLOOR PLAN is perfect for both entertaining and everyday living. Step outside to the huge covered and SCREENED PATIO overlooking a SPACIOUS YARD, offering plenty of room for a future pool if desired.
Inside, you’ll find NEWER FLOORING throughout, with every bathroom RENOVATED to perfection, including newer cabinetry and quartz countertops. The master suite is a true retreat, highlighted by an INCREDIBLE WALK-IN SHOWER with a RAIN shower head. This home was freshly painted INSIDE AND OUT in 2022, ensuring a move-in ready experience. Homes in this highly sought-after neighborhood are rarely available, and it’s easy to see why—residents love the convenient KEYSTONE location (just minutes from the Veterans Expressway and Citrus Park Mall), top-rated schools, and the variety of housing styles that give the community its unique character. If you’re looking for the CHARM of an ESTABLISHED NEIGHBORHOOD, combined with the FEEL OF A BRAND NEW HOME, this is the one you’ve been waiting for!

Features

  • Rooms: 3
  • Bedrooms: 4
  • Baths: 2 full / 1 half
  • Lot Size: 81 x 152
  • Laundry: Laundry Room
  • Year Built: 1987
  • Garage: 2-car
  • Heating: Electric
  • Cooling: Central Air
  • Approx Sq. Feet: 2,486
  • Acreage: 0.28
  • Lot Size: 81 x 152
  • Est. Taxes: $5,343
  • HOA Fee: $240 Annually
  • Elem. School: Hammond Elementary School
  • Middle School: Sergeant Smith Middle-HB
  • High School: Sickles-HB
  • Pet Policy: Yes
  • Appliances: Convection Oven, Cooktop, Dishwasher, Disposal, Dryer, Microwave, Range, Refrigerator, Washer, Wine Refrigerator
  • MLS#: T3549295
  • Days on Market: 5 days
  • Website: https://www.raveis.com
    /prop/T3549295/15605indianqueendrive_odessa_fl?source=qrflyer
This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this Site comes in part from the IDX Program of MFRMLS (My Florida Regional MLS DBA Stellar MLS). The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. (last updated 9/19/2024 3:07:57 AM)
Listing courtesy of MIHARA & ASSOCIATES INC.   Phone: 813-960-2300

William Raveis Family of Services

Our family of companies partner in delivering quality services in a one-stop-shopping environment. Together, we integrate the most comprehensive real estate, mortgage and insurance services available to fulfill your specific real estate needs.

Customer Service

888.699.8876

Contact@raveis.com

Our family of companies offer our clients a new level of full-service real estate. We shall:

  • Market your home to realize a quick sale at the best possible price
  • Place up to 20+ photos of your home on our website, raveis.com, which receives over 1 billion hits per year
  • Provide frequent communication and tracking reports showing the Internet views your home received on raveis.com
  • Showcase your home on raveis.com with a larger and more prominent format
  • Give you the full resources and strength of William Raveis Real Estate, Mortgage & Insurance and our cutting-edge technology

To learn more about our credentials, visit raveis.com today.

Melissa CohnRVP, Mortgage Banker, William Raveis Mortgage, LLC

NMLS Mortgage Loan Originator ID 16953

917.838.7300

Melissa.Cohn@raveis.com

Our Executive Mortgage Banker:

  • Is available to meet with you in our office, your home or office, evenings or weekends
  • Offers you pre-approval in minutes!
  • Provides a guaranteed closing date that meets your needs
  • Has access to hundreds of loan programs, all at competitive rates
  • Is in constant contact with a full processing, underwriting, and closing staff to ensure an efficient transaction

Robert ReadeRegional SVP Insurance Sales, William Raveis Insurance

860.690.5052

Robert.Reade@raveis.com

Our Insurance Division:

  • Will Provide a home insurance quote within 24 hours
  • Offers full-service coverage such as Homeowner's, Auto, Life, Renter's, Flood and Valuable Items
  • Partners with major insurance companies including Chubb, Kemper Unitrin, The Hartford, Progressive,
    Encompass, Travelers, Fireman's Fund, Middleoak Mutual, One Beacon and American Reliable

15605 Indian Queen DRIVE, Odessa, FL, 33556

$675,000

Customer Service

William Raveis Real Estate

Phone: 888.699.8876

Contact@raveis.com

Melissa Cohn

RVP, Mortgage Banker

William Raveis Mortgage, LLC

Phone: 917.838.7300

Melissa.Cohn@raveis.com

NMLS Mortgage Loan Originator ID 16953

5/6 (30 Yr)
Adjustable Rate Conforming*
30 Year
Fixed-Rate Conforming
15 Year
Fixed-Rate Conforming
Loan Amount $540,000 $540,000 $540,000
Term 360 months 360 months 180 months
Initial Interest Rate** 6.125% 5.990% 4.990%
Interest Rate based on Index + Margin 8.125%
Annual Percentage Rate 7.470% 6.161% 5.248%
Monthly Tax Payment $445 $445 $445
H/O Insurance Payment $92 $92 $92
Initial Principal & Interest Pmt $3,281 $3,234 $4,267
Total Monthly Payment $3,818 $3,771 $4,804

* The Initial Interest Rate and Initial Principal & Interest Payment are fixed for the first and adjust every six months thereafter for the remainder of the loan term. The Interest Rate and annual percentage rate may increase after consummation. The Index for this product is the SOFR. The margin for this adjustable rate mortgage may vary with your unique credit history, and terms of your loan.

** Mortgage Rates are subject to change, loan amount and product restrictions and may not be available for your specific transaction at commitment or closing. Rates, and the margin for adjustable rate mortgages [if applicable], are subject to change without prior notice.

The rates and Annual Percentage Rate (APR) cited above may be only samples for the purpose of calculating payments and are based upon the following assumptions: minimum credit score of 740, 20% down payment (e.g. $20,000 down on a $100,000 purchase price), $1,950 in finance charges, and 30 days prepaid interest, 1 point, 30 day rate lock. The rates and APR will vary depending upon your unique credit history and the terms of your loan, e.g. the actual down payment percentages, points and fees for your transaction. Property taxes and homeowner's insurance are estimates and subject to change.  The Total Monthly Payment does not include the estimated HOA/Common Charge payment.