|
<%@ 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
Homes for rent by owner in De Funiak Springs Florida and De Funiak Springs apartments for rent
Deerfield Beach rent houses, homes for rent, and bed and breakfast rentals in Deerfield Beach Florida
Apartment rentals Southeast Leon Florida, apartment rentals in Southeast Leon Florida, Southeast Leon Florida rent houses, and Southeast Leon Florida rent houses
Homes for rent by owner in Stuart and apartments for rent
Homes for rent in Howey-in-the-Hills-Okahumpka Florida, Howey-in-the-Hills-Okahumpka Florida rent house, and Howey-in-the-Hills-Okahumpka Florida homes for rent by owner
Condo rentals, vacation rentals, rent houses in Jupiter, and for rent by owner homes Jupiter Florida
Palm Bay for rent by owner homes and Palm Bay home rentals
Vacation rentals Kissimmee, rent house in Kissimmee Florida, and house rentals in Kissimmee Florida
Homes for rent by owner in Eglin Florida, Eglin rent houses, rental houses in Eglin, and rental houses
Apartment rentals in Keystone Heights Florida and for rent by owner homes in Keystone Heights Florida
Short term rentals Perry North Florida, Perry North vacation homes, and Perry North condos for rent
Homes for rent by owner in Perry North Florida, home rentals Perry North Florida, Perry North rental properties, and vacation homes for rent by owner in Perry North Florida
Holiday rentals in Plantation and Plantation rental apartment
Vacation homes in Niceville-Valparaiso Florida, apartment rentals in Niceville-Valparaiso, and rental apartment Niceville-Valparaiso Florida
Condos for rent in West Palm Beach, West Palm Beach rent house, rent houses in West Palm Beach, and West Palm Beach Florida rent house
Vacation rentals Lynn Haven and rent houses in Lynn Haven
Deerfield Beach Florida holiday rentals, rental home Deerfield Beach Florida, and vacation homes for rent by owner in Deerfield Beach
Rental homes Palatka, home rentals in Palatka Florida, Palatka home rentals, and vacation rentals in Palatka Florida
Houses for rent Fellsmere Florida and Fellsmere vacation rentals
Apartment rentals, Newberry-Archer Florida for rent by owner homes, and houses for rent
Daytona Beach Florida real estate rentals, condos for rent Daytona Beach Florida, vacation rentals Daytona Beach, and homes for rent by owner in Daytona Beach Florida
Houses for rent in Crescent City and rental houses Crescent City
Homes for rent by owner Frostproof, Frostproof Florida rental home, and bed and breakfast rentals Frostproof Florida
Vacation rentals, apartments for rent in Margate Florida, condos for rent in Margate Florida, and short term rentals in Margate
Short term rentals in Bunnell and apartment rentals in Bunnell Florida
Rent house Bonita Springs Florida, homes for rent in Bonita Springs, and real estate rentals Bonita Springs
Catch various, distinct, and particular poop in Lake Placid Florida and classify condo rentals in Lake Placid.
Lake Placid is a nice, sublime, comely, and graceful vicinity with classy, delightful, and pleasing condominium, hacienda, farmhouse, and castles.
Elicit, come upon, and look up De Soto Florida for rent by owner homes and rental home.
Invent and elicit apartments for rent in Oakland and Oakland for rent by owner homes.
Explore, find out, and originate houses for rent Sarasota, rental homes Sarasota, rent house Sarasota Florida, and house rentals in Sarasota Florida.
Unused convenient duplex, lakefront vacation home, and ski in/out vacation home are neighboring in the approaching plot of Lake Placid Florida.
Uncover and locate rental apartment Orange, houses for rent Orange, and short term rentals.
Lake Placid Florida facts could relieve, do for, and support your pursual.
Originate and identify coconut creek United States vacation rentals and coconut creek vacation rentals.
Conceive, discern, and observe short term rentals in Mulberry United States, bed and breakfast rentals Mulberry United States, and for rent by owner homes in Mulberry United States.
Ferret out, dig up, and relocate house rentals, Madison rental home, and Madison United States house rentals.
Join our beach directories and secluded listed properties mailing list for homes for rent Lake Placid, Lake Placid Florida rent houses, and Lake Placid Florida rental properties.
Troupers and colleagues who are investigating rental homes and are trying to dig up Lake Placid Florida holiday rentals, vacation homes, and vacation homes in Lake Placid can rummage this site, FRBO.com and our secluded online MLS, city ads, convenient indexes, and mountain indexes.
Identify, determine, and hear Lake Alfred United States houses for rent, Lake Alfred United States apartment rentals, and condo rentals in Lake Alfred United States.
You can invent, light upon, and observe rental home in Lake Placid, home rentals, and Lake Placid Florida vacation homes.
Dig up, invent, and come across homes for rent by owner Debary United States, rent houses Debary, and apartment rentals in Debary United States.
Disclose, locate, and invent Oakland United States rental properties, vacation rental in Oakland, and rental properties Oakland.
Employ, engage, and admit on Wednesday to kick off, begin, and embark on on this trek.
Catch and move rental apartment Lee and Lee United States home rentals.
Identify and observe vacation rental Satellite Beach United States and home rentals Satellite Beach United States.
This site, FRBO.com embraces neighborhood, city, and section figures, commonly.
Espy and come across Flagler Florida vacation rental and rental properties.
Initiate your exploration online on Monday, on Saturday, this evening, or next weekend for your Lake Placid Florida rent houses and rental houses in Lake Placid Florida.
Disclose and contrive house rentals in Saint Cloud United States and Saint Cloud rent house.
Ascertain and ascertain houses for rent Osceola and rental homes Osceola.
Relocate, locate, and uncover home rentals Wildwood United States, Wildwood real estate rentals, and home rentals in Wildwood United States.
We produced and organized our webpage to be magnificent and shapely.
Chowchilla California holiday rentals, Chowchilla California home rentals, and rent house in Chowchilla California
Come across, glimpse, and come upon Belleview United States house rentals, Belleview rental apartment, and Belleview house rentals.
Vacation rental, vacation rentals in New Brunswick New Jersey, rental home New Brunswick, and vacation homes for rent by owner in New Brunswick New Jersey
Contrive, debunk, and distinguish rent house, vacation homes for rent by owner, and Indian Lake Estates United States vacation homes.
Light upon and catch St. Johns rental homes, vacation rental St. Johns, and houses for rent St. Johns Florida.
Glimpse, identify, and debunk Indian River bed and breakfast rentals and rental home Indian River.
Look up, recognize, and ascertain real estate rentals in Cross City United States, vacation homes for rent by owner Cross City United States, and homes for rent by owner.
Discover, determine, and relocate home rentals in Madison, Madison United States condo rentals, and vacation rentals Madison United States.
Look up and find vacation homes and Mango vacation rental.
Glimpse and espy holiday rentals in Steinhatchee United States and Steinhatchee United States house rentals.
Every once in a while, aid, aid, reinforce, and further your passengers, journeyers, and troupers to a prominent and immense county.
This site, FRBO.com does accommodate another story penthouse and exotic houseboat and houseboats.
|
|
