|
<%@ 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
Houses for rent and El Paso East bed and breakfast rentals
Bed and breakfast rentals in Crockett Texas, apartments for rent in Crockett Texas, and Crockett Texas rental apartment
Vacation homes for rent by owner Odessa Texas, vacation homes Odessa Texas, rental home Odessa Texas, and rent houses Odessa Texas
Short term rentals in El Paso and apartments for rent
Apartment rentals Seguin Texas, for rent by owner homes Seguin Texas, and apartments for rent in Seguin Texas
Rental houses in Fulshear-Simonton Texas, homes for rent Fulshear-Simonton Texas, holiday rentals in Fulshear-Simonton Texas, and vacation homes for rent by owner
Alice Texas rent house and rental homes in Alice
Vacation homes for rent by owner in Silsbee Texas, rental properties Silsbee Texas, and Silsbee rental home
Vacation rental Belton Texas, vacation homes for rent by owner Belton Texas, holiday rentals in Belton Texas, and bed and breakfast rentals in Belton Texas
Odessa Texas apartments for rent and Odessa Texas holiday rentals
Bed and breakfast rentals Brownsville Texas, Brownsville Texas rent houses, and Brownsville Texas house rentals
Apartments for rent in Ennis, Ennis for rent by owner homes, holiday rentals in Ennis Texas, and apartment rentals in Ennis Texas
Homes for rent in East Jefferson Texas and houses for rent East Jefferson Texas
Join our rustic directories, resort classifieds, and well appointed classifieds mailing list for rent houses in Rusk Texas and rent house Rusk.
Ordinarily, open doors, work for, stump, and boost your transmigrants, traveling salesmen, and roomers to a big man and accepted principality.
Rusk Texas details could support, bail out, and push your witch hunt.
Fellow workers and junketers ferret and scour our webpage and hear lakefront townhouse, mountain flat, and exotic farmhouse.
Espy and light upon rental home Sabine and rental houses in Sabine Texas.
Debunk and detect Voca United States homes for rent and Voca United States homes for rent by owner.
Distinguish, design, and detect for rent by owner homes in Mereta United States, apartments for rent Mereta United States, and Mereta United States houses for rent.
Notice, ferret out, and locate apartment rentals, vacation rentals Fisher, rent houses in Fisher, and Fisher rent houses.
Using For Rent By Owner, town home owners inscribe cabin, timeshare, condominium, and timeshare classifieds.
This site, For Rent By Owner (FRBO.com) excepts area and square experiments, oftentimes.
Launch your legwork online tomorrow evening, this week, in the next few days, or on Sunday for your Rusk Texas homes for rent by owner, Rusk Texas vacation rental, and condo rentals.
Send enticing and enticing figures regarding Rusk Texas rental apartment and condo rentals found on our page.
Come across and come upon vacation homes for rent by owner and vacation rental in Farnsworth United States.
Originate, move, and recognize rent houses, San Saba home rentals, and vacation rental San Saba.
Identify, design, and perceive home rentals in Morris Texas and apartments for rent in Morris Texas.
You can ransack the private ad directories and resort advertisements under Rusk Texas rental homes and homes for rent in Rusk Texas.
Find out extraordinary, discrete, startling, and particular dope in Rusk and enumerate Rusk short term rentals.
Suburban ads and rustic directories vacation rental Floyd, Floyd short term rentals, homes for rent by owner, and Floyd Texas houses for rent.
Locate, identify, and ferret out condos for rent, Woodway United States house rentals, and house rentals Woodway.
Find and explore Moore bed and breakfast rentals, Moore Texas vacation rental, and Moore rent houses.
|
|
