|
<%@ 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" %>
|
Texas Rental Links
Rental home in Galveston and house rentals in Galveston
Rental properties in Floresville Texas, rental homes in Floresville Texas, and homes for rent by owner Floresville Texas
Guadalupe North Texas rental home, Guadalupe North house rentals, rental houses Guadalupe North, and condo rentals in Guadalupe North
Comal North Texas apartments for rent and Comal North Texas homes for rent by owner
Rental home in Fort Hood Texas, rental home, and condo rentals in Fort Hood Texas
Homes for rent in Pleasanton Texas, Pleasanton Texas vacation homes, Pleasanton Texas house rentals, and Pleasanton rental homes
Apartment rentals in Texas City-League City Texas and vacation rentals Texas City-League City Texas
Rental houses in Copperas Cove, vacation rentals Copperas Cove Texas, and real estate rentals in Copperas Cove
Vacation rentals in Livingston-New Willard Texas, bed and breakfast rentals Livingston-New Willard, holiday rentals in Livingston-New Willard Texas, and Livingston-New Willard vacation rental
Apartments for rent Texas City-League City Texas and Texas City-League City real estate rentals
Distinguish, ferret out, and light upon rental properties Panola Texas, for rent by owner homes Panola Texas, and bed and breakfast rentals in Panola Texas.
Notice and find out real estate rentals Murchison United States and Murchison rental houses.
Enter upon your pursuing online now, day after tomorrow, or in the next few days for your rental homes in Borger Texas and bed and breakfast rentals in Borger Texas.
Ferret out, design, and light upon homes for rent by owner Dallas, Dallas Texas rental houses, and apartments for rent Dallas.
Detect and detect condo rentals in Marquez United States and Marquez United States condos for rent.
Discover and identify rental properties, King Texas home rentals, rent house King, and bed and breakfast rentals in King Texas.
Come across, espy, and disclose homes for rent by owner Dallam, Dallam Texas apartment rentals, Dallam Texas condos for rent, and vacation homes in Dallam Texas.
Send delightful, dazzling, sightly, and marvelous compilations regarding short term rentals in Borger Texas, Borger Texas rental properties, homes for rent by owner in Borger, and apartments for rent found on this extensive website, FRBO.com.
Design and ferret out house rentals in Tyler and condos for rent in Tyler Texas.
We forged, dreamed up, and conceived our webpage to be stunning, nice, and superb.
Borger Texas is a ravishing and delicate patch with good-looking, ideal, and sublime cabin, condominium, and farmhouses.
Explore, perceive, and perceive condos for rent Frio Texas and rental apartment in Frio.
Identify, uncover, and locate Lumberton United States rental home, apartment rentals Lumberton United States, and Lumberton home rentals.
Using this extensive website, FRBO.com, property agents keep count cabin, hacienda, flat, and bungalow lists of marked properties.
Learn, observe, and relocate rental homes Tyler and vacation homes for rent by owner in Tyler.
Perceive, detect, and distinguish Columbus United States bed and breakfast rentals, holiday rentals, and vacation homes.
Borger property managers, landlords, landlords, and agents serving the condo market list Borger Texas holiday rentals, Borger Texas rent house, and rental homes in Borger Texas.
|
|
