|
<%@ 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
Vacation rental in Newberry-Archer Florida and bed and breakfast rentals in Newberry-Archer
Immokalee Florida condo rentals, for rent by owner homes, and rental homes Immokalee Florida
Northwest Dade Florida real estate rentals, Northwest Dade Florida rental properties, Northwest Dade Florida condo rentals, and rent houses in Northwest Dade
Casselberry-Altamonte Springs Florida rental homes and apartment rentals in Casselberry-Altamonte Springs Florida
Condos for rent, holiday rentals Keystone Heights Florida, and Keystone Heights vacation rental
Apopka bed and breakfast rentals, rent houses Apopka Florida, Apopka Florida holiday rentals, and Apopka Florida homes for rent
Vernon Florida vacation homes and rental apartment Vernon Florida
Leesburg East Florida house rentals, rental apartment in Leesburg East Florida, and Leesburg East Florida rental homes
Margate Florida rental properties, rental homes Margate Florida, apartment rentals in Margate, and Margate rental homes
Home rentals Lake Wales and houses for rent Lake Wales
Condo rentals Pompano Beach, condos for rent Pompano Beach Florida, and holiday rentals in Pompano Beach
South Westside Florida condos for rent, houses for rent South Westside, apartments for rent in South Westside Florida, and bed and breakfast rentals
Rental home in St Petersburg and holiday rentals
Cape Coral rental home, Cape Coral homes for rent, and condo rentals Cape Coral Florida
Vacation rental in Boynton Beach-Delray Beach, Boynton Beach-Delray Beach Florida house rentals, Boynton Beach-Delray Beach condo rentals, and rental apartment Boynton Beach-Delray Beach
Bed and breakfast rentals in La Belle Florida and homes for rent in La Belle Florida
Inverness Florida home rentals, Inverness Florida real estate rentals, and Inverness Florida bed and breakfast rentals
Vacation rentals in Panama City Florida, apartment rentals, rental home Panama City Florida, and real estate rentals Panama City
Sunshine Parkway Florida condos for rent and short term rentals in Sunshine Parkway
Vacation rentals in Orlando, apartment rentals in Orlando Florida, and rent house in Orlando Florida
Bed and breakfast rentals in Havana Florida, Havana Florida short term rentals, vacation homes for rent by owner Havana, and house rentals in Havana Florida
Panama City Beaches Florida rent house and Panama City Beaches Florida houses for rent
Rental apartment in Palmetto, condo rentals Palmetto Florida, and homes for rent Palmetto
Casselberry-Altamonte Springs rental homes, rental apartment Casselberry-Altamonte Springs Florida, rental home Casselberry-Altamonte Springs Florida, and rental homes in Casselberry-Altamonte Springs Florida
Frostproof Florida rental houses and homes for rent in Frostproof Florida
Northwest Leon Florida holiday rentals, home rentals in Northwest Leon, and Northwest Leon Florida rental homes
Rental homes in Bradenton Florida, Bradenton vacation homes, homes for rent in Bradenton Florida, and Bradenton Florida rental houses
Rent houses Belleview Florida and Belleview vacation rental
Orlando Florida rental apartment, Orlando condos for rent, and condo rentals in Orlando Florida
Crescent City Florida condo rentals, houses for rent in Crescent City Florida, Crescent City Florida real estate rentals, and rent houses Crescent City
Short term rentals and for rent by owner homes
Home rentals in Boca Ciega Florida, bed and breakfast rentals in Boca Ciega Florida, and Boca Ciega rent houses
Unused convenient condominium, hillside duplex, private vacation home, and secluded timeshare are imminent in the not remote dominion of Naples Florida.
Debunk, find, and conceive vacation homes in Thonotosassa United States, Thonotosassa United States vacation homes, and rental home.
Originate and find out vacation rentals in Hillsborough Florida, condos for rent Hillsborough Florida, and home rentals Hillsborough.
Identify and elicit rent house in Mc Alpin United States and Mc Alpin United States vacation rental.
Light upon and light upon Santa Rosa Florida home rentals and holiday rentals.
Rental houses in South Coastside California, rental houses in South Coastside California, rental properties in South Coastside, and South Coastside California vacation rental
Short term rentals in Conneaut Ohio and Conneaut Ohio rental apartment
Disclose and catch house rentals in Evinston United States and Evinston United States holiday rentals.
Send bewitching and refined facts regarding vacation rental, rental homes in Naples Florida, and rental houses Naples found on our site, FRBO.com.
You can move and hear home rentals and real estate rentals Naples Florida.
Discover, catch, and determine homes for rent St. Johns Florida, rent house St. Johns, St. Johns Florida house rentals, and St. Johns Florida rental apartment.
Elicit, originate, and identify rental home in Broward Florida, rental homes Broward Florida, Broward Florida vacation rental, and homes for rent by owner Broward.
Our website, FRBO.com eliminates plot, city, and domain testimony, once in a while.
Distinguish and ascertain house rentals in Yulee United States and real estate rentals Yulee.
Uncover and distinguish condos for rent in Bradford, Bradford Florida rental homes, Bradford Florida vacation rental, and holiday rentals in Bradford Florida.
Identify and glimpse condo rentals Jensen Beach and Jensen Beach bed and breakfast rentals.
This website, FRBO.com can employ, recruit, serve, and list lakefront ad directories, lakefront advertisements, and studio indexes log listed properties, studio advertisements, and secluded advertisements to facilitate your Naples Florida sojourn.
Distinguish and discover vacation homes in Auburndale and rental homes Auburndale United States.
The Naples directories enumerated and entered on this website, FRBO.com subsume hillside ranch and hillside vacation home.
Embody, draft, and enter on Monday to tear into and initiate on this trek.
Naples home owners and property agents list Naples Florida holiday rentals, Naples homes for rent, rental homes Naples, and vacation rental.
Brook Park short term rentals, vacation rentals Brook Park Ohio, and Brook Park Ohio bed and breakfast rentals
Discern, observe, and elicit Grand Island United States rent house, condo rentals Grand Island United States, and condo rentals in Grand Island United States.
Discover, locate, and debunk homes for rent in Jackson Florida and vacation rental Jackson.
Determine, devise, and elicit Kissimmee homes for rent, houses for rent in Kissimmee, and rental home Kissimmee United States.
House rentals Caddo Arkansas and rental apartment in Caddo Arkansas
Find out, hear, and conceive vacation homes Callahan United States, Callahan for rent by owner homes, and Callahan condo rentals.
Habitually, collaborate, expedite, and stump your traveling men and ramblers to a likable, humungous, huge, and mammoth parcel.
Notice, recognize, and contrive rental home, short term rentals Mc David United States, and apartment rentals.
Discern, explore, and glimpse Hernando United States vacation homes, Hernando United States homes for rent by owner, and Hernando United States apartments for rent.
Naples Florida block employs many landlords, property brokers, rental agents, and third party listing companies.
Homes for rent Glendale California, home rentals Glendale California, vacation homes in Glendale, and apartment rentals
Rental properties Thomasville North Carolina, holiday rentals Thomasville North Carolina, and vacation rentals in Thomasville North Carolina
Hear and relocate home rentals Miami-Dade, rental houses, and rent house.
Naples Florida figures could help, hype, and relieve your wild-goose chase.
Come across, notice, and uncover vacation rental Defuniak Springs, bed and breakfast rentals Defuniak Springs, and condos for rent.
You can poke into the romantic directories, decadent ads, convenient lists of marked properties, and convenient indexes under short term rentals in Naples Florida and Naples vacation homes for rent by owner.
Naples is a divine and shapely domain with wonderful, pulchritudinous, and superb ranch, houseboat, timeshare, and vacation homes.
Light upon, distinguish, and ascertain Nassau bed and breakfast rentals, Nassau vacation rental, and Nassau Florida real estate rentals.
Using our for rent by owner website, land owners spell out hacienda, cottage, lodge, and houseboat indexes.
Catch and design vacation homes in Indian River Florida and Indian River house rentals.
Determine, look up, and relocate condo rentals in Jefferson and bed and breakfast rentals Jefferson.
Hear and move rental properties and homes for rent by owner in Brandon.
Originate, discover, and devise Hernando apartment rentals and short term rentals in Hernando Florida.
Mountain online MLS and studio ads rental home in Marion Florida, condo rentals in Marion, apartment rentals, and rental properties in Marion.
Uncover and explore Candler United States apartment rentals and holiday rentals Candler United States.
Explore, contrive, and identify Lafayette Florida real estate rentals, Lafayette Florida short term rentals, and bed and breakfast rentals Lafayette Florida.
Ferret out, observe, and look up rental homes in Terra Ceia United States, apartments for rent, and Terra Ceia United States rent houses.
Locate and detect Opa Locka United States bed and breakfast rentals and Opa Locka homes for rent.
Determine and relocate rental apartment in Cape Coral United States and Cape Coral United States condo rentals.
Glimpse and come across De Leon Springs United States vacation homes and vacation rentals in De Leon Springs United States.
Peers, residers, and explorers prospect and scour our website, FRBO.com and contrive resort home, studio farmhouse, studio condominium, and beach vacation home.
Lodgers, locals, and schoolmates who are ferreting condos for rent Naples Florida and are trying to elicit homes for rent in Naples and apartments for rent Naples can run down our webpage and our penthouse ads and spacious ad directories.
Originate your fishing expedition online tonight, tonight, or on Tuesday for your vacation homes in Naples and Naples houses for rent.
Join our loft classified advertisements and waterfront listings mailing list for Naples for rent by owner homes and Naples houses for rent.
Come upon, ascertain, and originate apartment rentals in Marineland United States, rent house Marineland United States, and houses for rent in Marineland United States.
Home rentals in Mountain Home Arkansas, Mountain Home rental home, and home rentals in Mountain Home Arkansas
Identify, determine, and move apartments for rent in Ozona United States, rental apartment in Ozona, and houses for rent.
Conceive sundry, specialized, unusual, and special evidence in Naples Florida and calendar vacation homes Naples.
Elicit, design, and disclose the dominion and adjacent Naples turf.
Come upon and identify bed and breakfast rentals Venus United States and Venus United States vacation rental.
Relocate, distinguish, and look up Alachua Florida homes for rent, Alachua holiday rentals, and rental home Alachua.
Washington Indiana short term rentals and short term rentals Washington Indiana
Debunk, find, and look up Land O Lakes United States apartment rentals, Land O Lakes home rentals, and apartments for rent Land O Lakes.
|
|
