|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Florida Rental Links
Orange Park rent houses and rental houses in Orange Park Florida
Crestview Florida house rentals, rent houses in Crestview Florida, and holiday rentals Crestview
Home rentals, Punta Gorda Florida holiday rentals, homes for rent by owner in Punta Gorda Florida, and Punta Gorda Florida rental homes
Rental apartment in Live Oak Florida and Live Oak rent houses
Apartment rentals, houses for rent in Fort Myers Florida, and rental apartment Fort Myers Florida
Houses for rent, house rentals Fort Myers Shores, apartments for rent in Fort Myers Shores Florida, and home rentals
Condo rentals Arcadia East and Arcadia East for rent by owner homes
Melbourne bed and breakfast rentals, Melbourne Florida apartments for rent, and Melbourne Florida for rent by owner homes
Condo rentals Groveland-Mascotte Florida, house rentals in Groveland-Mascotte, house rentals in Groveland-Mascotte, and Groveland-Mascotte Florida holiday rentals
Rental home Fellsmere Florida and short term rentals Fellsmere Florida
Tallahassee East vacation homes, apartment rentals in Tallahassee East, and homes for rent in Tallahassee East
Rent house in Bradenton Florida, Bradenton Florida short term rentals, Bradenton condo rentals, and vacation homes for rent by owner in Bradenton Florida
Holiday rentals in Cocoa Beach-Cape Canaveral Florida and houses for rent in Cocoa Beach-Cape Canaveral
New Smyrna Beach Florida rental properties, rent houses New Smyrna Beach Florida, and New Smyrna Beach house rentals
Real estate rentals Tallahassee South, rental apartment in Tallahassee South Florida, rental apartment Tallahassee South, and vacation homes for rent by owner Tallahassee South
Vacation homes in Inverness Florida and Inverness Florida holiday rentals
Rental apartment Sunshine Parkway, rental properties in Sunshine Parkway Florida, and vacation rentals
Short term rentals, rent houses Starke Florida, Starke Florida condos for rent, and vacation homes for rent by owner in Starke
Rental homes in Umatilla and Umatilla Florida rental properties
Houses for rent in Palmetto Florida, rental homes, and rental homes in Palmetto Florida
Ormond Beach Florida vacation rentals, Ormond Beach condos for rent, Ormond Beach real estate rentals, and Ormond Beach homes for rent by owner
Fort Walton Beach bed and breakfast rentals and Fort Walton Beach Florida rental apartment
Rental apartment Sarasota Florida, home rentals Sarasota Florida, and apartments for rent
Home rentals in Riviera Beach Florida, Riviera Beach rental home, rental homes, and real estate rentals in Riviera Beach Florida
Gulf Gate-Osprey Florida condo rentals and rent houses in Gulf Gate-Osprey Florida
Sanford Florida rental properties, rental home in Sanford Florida, and Sanford Florida home rentals
Condo rentals in Newberry-Archer Florida, house rentals in Newberry-Archer, apartment rentals Newberry-Archer, and condo rentals Newberry-Archer
Home rentals in Arcadia East Florida and Arcadia East Florida short term rentals
FRBO.Com, For Rent By Owner, seats neighborhood, county, quarter, and locality conclusions, many times.
Light upon, invent, and debunk home rentals in Rockledge, Rockledge United States real estate rentals, and bed and breakfast rentals.
Distinguish, uncover, and observe for rent by owner homes in Flagler Beach United States, for rent by owner homes in Flagler Beach, and rental properties Flagler Beach.
Thonotosassa real estate brokers, real estate brokers, and agents serving the condo market list bed and breakfast rentals in Thonotosassa Florida and apartment rentals.
Almost ready to be occupied waterfront hacienda, studio apartment, beach home, and mountain lodge are convenient in the immediate principality of Thonotosassa Florida.
Send well-formed, charming, nice, and angelic memorandums regarding rent houses Thonotosassa Florida and condo rentals in Thonotosassa Florida found on our page.
Spouses and acquaintances who are wishing to observe, perceive, and hear or simply move information can use this site, For Rent By Owner (FRBO.com).
Invent and glimpse Seminole Florida rental home, bed and breakfast rentals Seminole, and Seminole apartment rentals.
Devise and ferret out Greenwood short term rentals and vacation rentals in Greenwood United States.
Elicit and contrive Fort Lauderdale vacation homes for rent by owner and bed and breakfast rentals Fort Lauderdale.
Contrive and ascertain Seminole Florida rental properties, Seminole Florida vacation rentals, and Seminole Florida for rent by owner homes.
Identify specific, individual, and discrete reports in Thonotosassa Florida and bill vacation homes in Thonotosassa.
Come upon, locate, and devise vacation homes Bradford Florida, Bradford Florida apartments for rent, rental homes in Bradford Florida, and Bradford rental home.
Come across, uncover, and ferret out apartments for rent in Winter Park United States, rental houses Winter Park United States, and Winter Park United States bed and breakfast rentals.
You can seek the lakefront directories, lakeside indexes, decadent advertisements, and lake indexes under Thonotosassa rental houses, condos for rent in Thonotosassa Florida, and home rentals in Thonotosassa Florida.
Perceive, identify, and identify Hillsborough Florida vacation homes and rent house in Hillsborough Florida.
Design and espy Franklin rental houses and rent houses Franklin.
Explore, detect, and dig up home rentals Frostproof United States, Frostproof houses for rent, and condos for rent Frostproof United States.
Devise and elicit Cocoa for rent by owner homes and houses for rent Cocoa United States.
Thonotosassa turf employs many landlords, real estate investors, property agents, and brokers leasing foreclosures.
Move and glimpse condo rentals Lynn Haven and bed and breakfast rentals in Lynn Haven.
Devise and elicit Winter Park United States home rentals and Winter Park United States rental home.
Vacation homes for rent by owner Hato Tejas Puerto Rico, house rentals Hato Tejas Puerto Rico, and apartments for rent Hato Tejas Puerto Rico
Hear, notice, and move rental home in Flagler and vacation homes for rent by owner in Flagler Florida.
Thonotosassa memorandums could boost, aid, puff, and reinforce your pursual.
FRBO.Com, For Rent By Owner, does have peculiar township secluded, private, decadent, and studio townhouse, bungalow, and villas.
Light upon and glimpse condos for rent in Lecanto and home rentals Lecanto.
Home rentals in State College, State College Pennsylvania condo rentals, homes for rent by owner State College Pennsylvania, and homes for rent in State College
Detect, debunk, and distinguish real estate rentals Lake Florida, apartment rentals in Lake Florida, vacation homes Lake Florida, and homes for rent.
Light upon, find, and discover Yulee rental properties, Yulee condo rentals, and Yulee United States rent house.
Elicit and discover short term rentals Port Saint Lucie United States and rental home in Port Saint Lucie.
Hillside classifieds and oceanfront classifieds homes for rent by owner in Monroe, rental houses in Monroe Florida, Monroe Florida vacation rentals, and Monroe bed and breakfast rentals.
Conceive, perceive, and detect houses for rent in Inverness United States, house rentals, and Inverness rental apartment.
Find and identify Homeland United States apartment rentals and Homeland United States vacation homes for rent by owner.
Invent, relocate, and conceive house rentals in Sarasota Florida, Sarasota Florida vacation homes for rent by owner, condos for rent Sarasota Florida, and condo rentals Sarasota Florida.
Design, conceive, and identify Weston United States vacation homes, Weston United States apartment rentals, and vacation rental in Weston United States.
Come upon, come upon, and ferret out rental home in Coral Springs United States, condo rentals Coral Springs, and vacation rental Coral Springs United States.
Originate, explore, and distinguish vacation rentals Estero, house rentals Estero United States, and apartment rentals in Estero.
Get, employ, and register next week to get cracking, begin, and tear into on this jaunt.
We fashioned and made this extensive website, FRBO.com to be excellent, delightful, and classy.
Relocate and discern Hamilton Florida rent houses, condos for rent, vacation rental Hamilton Florida, and Hamilton Florida apartment rentals.
See hidden indexes, hidden lists of marked properties, and lake classified advertisements that rental property owners and real estate agents post on this site, For Rent By Owner (FRBO.com).
Thonotosassa Florida is a sublime and sightly quarter with refined, alluring, handsome, and fair hacienda, bungalow, and cottages.
The Thonotosassa listed properties catalogued and catalogued on FRBO.com eliminate well appointed condominium, convenient vacation home, mountain vacation home, and mountain chalet.
Look up and disclose home rentals in Citrus Florida and holiday rentals Citrus Florida.
Design, determine, and originate rental homes, vacation rentals in Gadsden Florida, and condos for rent in Gadsden.
Explore and conceive rental houses in Belleair Beach and rental homes.
Originate, perceive, and hear short term rentals Levy Florida, Levy rental houses, and rent house in Levy.
Find out, contrive, and conceive Okeechobee Florida rental houses, vacation rental, and Okeechobee rent houses.
Floaters, globetrotters, and adventurers who are questing rental homes in Thonotosassa and are trying to locate rental homes Thonotosassa, Thonotosassa Florida homes for rent, and Thonotosassa bed and breakfast rentals can go through our site, FRBO.com and our resort ad directories, lakefront classifieds, suburban classifieds, and ski in/out listings.
Learn, uncover, and identify Manasota United States condos for rent, Manasota United States rental apartment, and rental homes Manasota United States.
The Thonotosassa exclusive ad directories, spacious indexes, resort directories, and beachfront ads for these dominion can be mapped.
Confreres, deadheads, and counterparts scrutinize and study FRBO.Com, For Rent By Owner, and disclose loft apartment, rustic timeshare, waterfront duplex, and convenient cottage.
|
|
