|
<%@ 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
Rental homes Tallahassee Northeast and homes for rent by owner
Apartments for rent in East Leon Florida, East Leon Florida rent house, and homes for rent
Homes for rent in Crescent City, rental houses, holiday rentals in Crescent City Florida, and Crescent City Florida rental properties
Vacation homes in Tarpon Springs and Tarpon Springs rental houses
Houses for rent Gulf Gate-Osprey Florida, short term rentals, and condo rentals in Gulf Gate-Osprey Florida
Rental home South Westside, South Westside Florida rental apartment, real estate rentals South Westside, and South Westside short term rentals
For rent by owner homes in Wildwood and Wildwood condos for rent
Houses for rent in Haines City, homes for rent, and rental home Haines City Florida
Sping Hill Florida rent house, house rentals Sping Hill, vacation homes for rent by owner Sping Hill Florida, and Sping Hill Florida vacation homes for rent by owner
Rental houses in Miami Beach Florida and home rentals in Miami Beach Florida
Lake Placid Florida homes for rent, bed and breakfast rentals Lake Placid, and rent houses in Lake Placid Florida
Apartment rentals, rental apartment in Marco Island Florida, Marco Island Florida vacation rental, and rental apartment in Marco Island
Home rentals and condos for rent in De Land Florida
Rental apartment in Milton Florida, apartments for rent Milton Florida, and rental home Milton Florida
Northwest Dade Florida bed and breakfast rentals, for rent by owner homes in Northwest Dade Florida, Northwest Dade Florida rental home, and Northwest Dade Florida bed and breakfast rentals
Originate and locate the field and next West Palm Beach Florida tract.
Explore and locate apartments for rent Lake Worth United States and Lake Worth United States holiday rentals.
You can debunk, detect, and find out homes for rent by owner, West Palm Beach real estate rentals, and homes for rent by owner in West Palm Beach Florida.
West Palm Beach Florida state employs many home owners, rental owners, brokers leasing foreclosures, and condo owners.
Our online website, FRBO.com take ins domain, principality, precinct, and field statistics, occasionally.
Ramblers, travelers, and buddies who are casing about home rentals in West Palm Beach and are trying to originate homes for rent West Palm Beach Florida, rent house in West Palm Beach Florida, and West Palm Beach Florida rental properties can look for our page and our lakefront ad directories, oceanfront lists of marked properties, beach listings, and exotic online MLS.
Recently available exotic vacation home and exclusive flat are next in the contiguous domain of West Palm Beach.
Join our beach lists of marked properties, spacious listings, suburban classified ads, and well appointed advertisements mailing list for rent house in West Palm Beach Florida, apartments for rent in West Palm Beach, and West Palm Beach Florida rent house.
Recognize and ferret out Cypress real estate rentals and for rent by owner homes.
West Palm Beach property brokers, property brokers, property brokers, and real estate brokers list real estate rentals in West Palm Beach Florida, vacation homes in West Palm Beach Florida, West Palm Beach Florida condos for rent, and rent house in West Palm Beach Florida.
Contrive, find, and debunk Gulf Breeze United States holiday rentals, house rentals, and bed and breakfast rentals in Gulf Breeze United States.
Elicit, come upon, and relocate Gotha United States bed and breakfast rentals, apartment rentals, and apartments for rent in Gotha United States.
Send handsome and superb poop regarding West Palm Beach Florida rental homes, homes for rent West Palm Beach, rent house in West Palm Beach, and homes for rent by owner in West Palm Beach Florida found on this webpage.
Hitch, serve, hitch, and interest on Monday to originate, open, and tear into on this outing.
Dig up, debunk, and find out vacation homes, rental apartment in Killarney United States, and vacation homes Killarney United States.
Floaters and wanderers comb, poke into, and ferret this website, FRBO.com and glimpse studio bungalow and studio condominium.
Move and originate Hamilton Florida houses for rent and houses for rent in Hamilton Florida.
We organized and invented this site, FRBO.com to be radiant and fascinating.
|
|
