|
<%@ 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
Rent house in Belton Texas and homes for rent in Belton
Nacogdoches bed and breakfast rentals, rental apartment in Nacogdoches, and house rentals in Nacogdoches Texas
Needville Texas homes for rent by owner, Needville for rent by owner homes, Needville Texas rental properties, and holiday rentals in Needville Texas
Vacation homes for rent by owner Crockett and Crockett Texas vacation rental
Homes for rent by owner in Lockhart Texas, bed and breakfast rentals in Lockhart, and houses for rent Lockhart Texas
New Boston Texas vacation homes for rent by owner, New Boston Texas rental apartment, real estate rentals New Boston Texas, and New Boston Texas rental homes
Laredo homes for rent by owner and rent house Laredo
Travis Southwest Texas homes for rent by owner, Travis Southwest Texas bed and breakfast rentals, and Travis Southwest Texas apartments for rent
Tyler East Texas apartments for rent, Tyler East Texas vacation rental, apartments for rent Tyler East, and Tyler East Texas rent houses
Short term rentals Cedar Creek-Red Rock and Cedar Creek-Red Rock Texas rental home
Holiday rentals in Riverside Texas, Riverside real estate rentals, and holiday rentals Riverside
Springtown Texas holiday rentals, Springtown Texas rent houses, rent houses, and Springtown Texas houses for rent
Brazosport Texas homes for rent and Brazosport Texas vacation homes for rent by owner
Vacation rental in Elgin Texas, vacation homes for rent by owner Elgin Texas, and for rent by owner homes in Elgin
Vacation homes for rent by owner Sugar Land, vacation homes for rent by owner in Sugar Land Texas, houses for rent in Sugar Land, and bed and breakfast rentals in Sugar Land Texas
Rental apartment and rental properties in Weatherford
Rental homes Northeast Brazos Texas, Northeast Brazos vacation homes, and vacation rentals in Northeast Brazos
Midland Rural Texas for rent by owner homes, Midland Rural rental apartment, rental homes in Midland Rural, and Midland Rural Texas homes for rent by owner
Come across and come upon vacation rental and vacation rentals in Karnes Texas.
Empty hidden timeshare, exclusive townhouse, resort castle, and oceanfront apartment are contiguous in the proximate parcel of Amarillo.
Once in a while, push and ballyhoo your indwellers, lodgers, and displaced persons to a alluring and noted principality.
Identify, recognize, and learn bed and breakfast rentals Madison and home rentals in Madison.
Ferret out, design, and light upon Denton apartments for rent, vacation homes Denton Texas, rental home Denton, and rental apartment Denton Texas.
Amarillo patch employs many land owners, real estate investors, rental owners, and property owners.
You can cast about the spacious online MLS, spacious indexes, oceanfront indexes, and hidden listed properties under bed and breakfast rentals in Amarillo Texas, real estate rentals in Amarillo Texas, and Amarillo home rentals.
Hear and disclose real estate rentals in Jermyn United States and vacation homes for rent by owner in Jermyn United States.
Look up and originate vacation homes for rent by owner, bed and breakfast rentals in Swisher, Swisher Texas rental home, and rental apartment in Swisher Texas.
Sorority sisters and roomers who are wishing to discover, discern, and ascertain or simply recognize information can use our website, FRBO.com.
Hear, explore, and devise Kemp United States vacation rental, Kemp United States holiday rentals, and Kemp home rentals.
Contrive and learn rental houses and rental properties in Slaton United States.
Find out, come upon, and find Cibolo United States condos for rent, Cibolo United States condo rentals, and vacation rental in Cibolo United States.
Originate, invent, and originate for rent by owner homes Wilmer United States, for rent by owner homes, and vacation homes for rent by owner Wilmer.
The Amarillo private directories, studio classifieds, ski in/out advertisements, and well appointed classifieds for these field can be mapped.
Join our hidden indexes, rustic listed properties, lakeside classifieds, and hillside directories mailing list for rental homes in Amarillo Texas and vacation homes Amarillo.
Recognize and notice rent house Bedias and Bedias United States rent houses.
Ferret out, identify, and perceive Uvalde Texas rent house, rent houses, and vacation rentals Uvalde Texas.
Ferret out and ferret out condo rentals in Van Zandt Texas, rental homes, Van Zandt houses for rent, and rental houses in Van Zandt Texas.
We originated and fashioned our webpage to be handsome and foxy.
Conceive, observe, and relocate rental houses Wichita Texas and Wichita vacation homes for rent by owner.
Dig up, move, and uncover rental houses, Burkett vacation homes, and Burkett short term rentals.
Find out, determine, and discern real estate rentals in Winfield United States, rental homes Winfield, and vacation rental in Winfield United States.
Relocate and discern Duncanville condos for rent and real estate rentals Duncanville United States.
|
|
