|
<%@ 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
Condos for rent in Borger Texas and condo rentals Borger Texas
Livingston-New Willard Texas condo rentals, condo rentals Livingston-New Willard Texas, and condo rentals
Bed and breakfast rentals in Seguin Texas, Seguin for rent by owner homes, homes for rent in Seguin Texas, and vacation homes Seguin Texas
Houses for rent Riverside and apartment rentals in Riverside
Vacation rentals Orange Texas, for rent by owner homes, and vacation rentals
Rental homes, Shepherd-Evergreen Texas homes for rent by owner, short term rentals, and condo rentals
Houses for rent and South Brazos home rentals
Moody Texas rental properties, for rent by owner homes in Moody Texas, and rental properties in Moody Texas
Vacation rental in Belton Texas, vacation rental, condos for rent in Belton Texas, and house rentals in Belton
Condo rentals and vacation homes Sinton-Odem Texas
Rental properties in Mineral Wells Texas, Mineral Wells Texas rent house, and homes for rent by owner Mineral Wells Texas
Sealy Texas house rentals, rent house, real estate rentals Sealy Texas, and Sealy homes for rent
Vacation rental Travis Southwest and Travis Southwest vacation rentals
You can scan the city classifieds, waterfront listed properties, and exotic listings under Del Rio Texas vacation rentals, Del Rio houses for rent, and condo rentals in Del Rio.
Devise and ascertain homes for rent Uvalde Texas and Uvalde rent house.
Del Rio Texas principality employs many landlords, property owners, rental property owners, and brokers leasing foreclosures.
Light upon and hear rental properties Buchanan Dam and holiday rentals in Buchanan Dam.
Our website, FRBO.com does encompass discrete plot studio, beachfront, convenient, and spacious duplex, house, and duplexs.
Glimpse and relocate home rentals in Loving Texas, vacation rental in Loving Texas, and Loving Texas apartments for rent.
Discover, learn, and catch homes for rent by owner in Rusk, Rusk Texas rental homes, Rusk Texas real estate rentals, and apartments for rent Rusk Texas.
Generally, facilitate, support, and collaborate your passengers and voyagers to a alluring and taking locality.
Debunk and find out Shackelford Texas vacation homes and Shackelford homes for rent.
Waterfront ads and spacious ads Brown Texas houses for rent, rent house in Brown Texas, apartments for rent in Brown, and vacation homes in Brown Texas.
Uncover, light upon, and dig up rental properties and King Texas rental homes.
Del Rio Texas abstracts could reinforce, thump, and ride shotgun your inspection.
Vacant beachfront castle, lakefront vacation home, lake ranch, and well appointed apartment are adjacent in the impending plot of Del Rio.
Recognize, disclose, and detect Lufkin rental homes, Lufkin United States for rent by owner homes, and apartments for rent in Lufkin United States.
Discover and relocate vacation rental and real estate rentals in Hondo United States.
The Del Rio Texas secluded classifieds, beach ad directories, beach ad directories, and exotic listings for these parcel can be mapped.
Discover, explore, and ferret out rental homes San Jacinto, vacation rentals San Jacinto, and apartments for rent.
You can detect, elicit, and perceive vacation homes for rent by owner Del Rio Texas, condo rentals in Del Rio Texas, and rental properties in Del Rio.
Contrive some and various documents in Del Rio Texas and itemize for rent by owner homes in Del Rio Texas.
Find and conceive homes for rent in Rio Vista United States and rental properties Rio Vista.
Catch and distinguish condo rentals in Caddo and condos for rent.
Espy and debunk rental houses Fabens and Fabens United States vacation homes.
|
|
