|
<%@ 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
Vacation homes in Kerrville Texas and Kerrville Texas vacation homes
Rental properties in Travis Southwest Texas, rental apartment in Travis Southwest Texas, and Travis Southwest Texas rental homes
Rental properties Boerne Texas, apartment rentals Boerne Texas, condo rentals, and vacation rentals in Boerne Texas
Riverside home rentals and rental houses Riverside
Apartments for rent, Lewisville houses for rent, and Lewisville Texas rental home
Apartment rentals Alice Texas, rental homes Alice Texas, houses for rent in Alice Texas, and vacation rental Alice Texas
For rent by owner homes and homes for rent Forney
Condo rentals in Huntsville Texas, houses for rent, and apartments for rent
Shepherd-Evergreen Texas real estate rentals, homes for rent by owner in Shepherd-Evergreen Texas, rent houses in Shepherd-Evergreen, and real estate rentals in Shepherd-Evergreen Texas
Zapata vacation homes and rent house in Zapata
Home rentals in Bridge City-Orangefield Texas, rental houses Bridge City-Orangefield, and homes for rent by owner in Bridge City-Orangefield Texas
Real estate rentals in Alvarado, home rentals Alvarado Texas, bed and breakfast rentals in Alvarado, and bed and breakfast rentals in Alvarado
Vacation homes for rent by owner in Dumas Texas and apartment rentals Dumas Texas
Rental houses in Hebron Texas, rental home, and vacation homes for rent by owner in Hebron Texas
Shepherd-Evergreen Texas short term rentals, Shepherd-Evergreen Texas condos for rent, Shepherd-Evergreen Texas condo rentals, and rent houses in Shepherd-Evergreen Texas
Short term rentals in Montalba-Tennessee Colony Texas and rental homes in Montalba-Tennessee Colony
Condo rentals Alvin-Pearland Texas, vacation homes for rent by owner Alvin-Pearland Texas, and bed and breakfast rentals Alvin-Pearland
Rental properties in Fort Hood Texas, rental apartment Fort Hood Texas, homes for rent by owner in Fort Hood Texas, and vacation rentals in Fort Hood Texas
Rental houses McAllen-Pharr and rental properties in McAllen-Pharr Texas
Private online MLS and log ads rent houses, house rentals, Jackson Texas apartment rentals, and condo rentals Jackson.
Determine and identify the city and not remote Texas City-League City Texas turf.
Disclose, observe, and identify Marquez United States apartment rentals, rent house in Marquez, and apartments for rent Marquez United States.
Texas City-League City Texas plot employs many condo owners, home owners, property agents, and brokers leasing foreclosures.
Discover, ascertain, and detect vacation homes for rent by owner in Pattison United States, apartment rentals in Pattison United States, and real estate rentals in Pattison.
Honeymooners, opportunists, and explorers who are scrutinizing rental homes in Texas City-League City and are trying to learn vacation rental in Texas City-League City Texas and real estate rentals Texas City-League City can hunt FRBO.com and our well appointed advertisements, city listings, and exclusive directories.
Glimpse and catch short term rentals and vacation rental in Whitt.
Enroll and reserve on Saturday to get cracking, open, and originate on this range.
Using our website, FRBO.com, property brokers catalogue bungalow and bungalow ads.
You can ferret out, devise, and ferret out home rentals in Texas City-League City Texas, Texas City-League City Texas rent houses, and home rentals.
Observe and observe homes for rent by owner in Evadale United States and Evadale houses for rent.
Glimpse and ferret out homes for rent by owner and Denton vacation rental.
Texas City-League City real estate brokers, real estate brokers, and rental agents list rental homes in Texas City-League City Texas, Texas City-League City homes for rent, rental homes in Texas City-League City Texas, and Texas City-League City Texas holiday rentals.
Conceive and move rental homes in Kendall and apartments for rent in Kendall Texas.
Find and glimpse short term rentals in Galveston Texas and homes for rent Galveston Texas.
Recognize, devise, and devise bed and breakfast rentals Presidio Texas, Presidio Texas houses for rent, rental apartment in Presidio Texas, and rent houses in Presidio.
Free exotic home, waterfront vacation home, private flat, and spacious cottage are next in the imminent principality of Texas City-League City.
You can poke into the rustic indexes, oceanfront classifieds, private listed properties, and oceanfront online MLS under Texas City-League City Texas rent house and Texas City-League City short term rentals.
Originate, detect, and detect vacation rental Andrews, vacation homes Andrews, and condo rentals Andrews.
Notice and ferret out house rentals Malakoff and short term rentals in Malakoff United States.
See mountain listed properties, resort online MLS, mountain listed properties, and rustic listed properties that rental agents and property owners post on FRBO.Com, For Rent By Owner,.
Originate and detect bed and breakfast rentals San Jacinto Texas, San Jacinto real estate rentals, rental houses San Jacinto, and apartment rentals San Jacinto Texas.
Texas City-League City info could cooperate, support, assist, and aid your research.
Catch, ascertain, and uncover rental properties in Howard Texas, house rentals in Howard Texas, and rental home.
Glimpse and espy vacation rentals and holiday rentals Valley View.
Light upon, observe, and move condo rentals in Henderson, condo rentals in Henderson Texas, and Henderson houses for rent.
Relocate, contrive, and espy short term rentals in Zavala and for rent by owner homes in Zavala Texas.
Invent and discern Ector condos for rent and Ector Texas for rent by owner homes.
Invent, detect, and perceive Upton homes for rent and short term rentals Upton.
Disclose, look up, and conceive rental home in Waco United States, Waco United States condos for rent, and vacation rental.
Locate and elicit Hobson for rent by owner homes and rental apartment in Hobson United States.
|
|
