|
<%@ 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
House rentals in Bay City Texas and rental home Bay City
Holiday rentals, vacation homes for rent by owner Tyler Texas, and rental homes in Tyler
Short term rentals Corsicana Texas, condo rentals Corsicana, vacation homes for rent by owner in Corsicana, and vacation rental Corsicana Texas
Rio Grande City-San Isidro Texas apartment rentals and rental homes Rio Grande City-San Isidro Texas
Castroville-LaCoste rental properties, Castroville-LaCoste vacation homes, and real estate rentals Castroville-LaCoste Texas
Colony Texas vacation rentals, Colony Texas apartments for rent, rental properties, and Colony Texas rental apartment
House rentals Palestine and Palestine Texas house rentals
Southeast Harris Texas homes for rent by owner, vacation homes in Southeast Harris, and Southeast Harris houses for rent
Dripping Springs-Wimberley Texas rental properties, Dripping Springs-Wimberley Texas house rentals, Dripping Springs-Wimberley condos for rent, and homes for rent in Dripping Springs-Wimberley Texas
House rentals in Corpus Christi and condos for rent Corpus Christi Texas
Apartments for rent, condos for rent in Ennis, and rental homes in Ennis Texas
Rent houses Killeen Texas, home rentals in Killeen Texas, for rent by owner homes in Killeen Texas, and Killeen houses for rent
Ascertain, determine, and identify apartments for rent in Afton United States, condos for rent, and vacation rentals in Afton United States.
Pre-leased convenient ranch, ski in/out vacation home, penthouse duplex, and city timeshare are next in the contiguous principality of Gatesville Texas.
Lead off your expedition online this weekend, on Monday, tonight, or in the next few days for your Gatesville vacation homes, Gatesville Texas bed and breakfast rentals, and Gatesville Texas rental home.
Oceanfront ad directories and log listed properties Borden rent houses, Borden condos for rent, vacation rental in Borden Texas, and Borden Texas rental properties.
Design and discern rental houses in Duval Texas, Duval Texas apartment rentals, vacation homes in Duval Texas, and Duval Texas rental home.
You can scout the exclusive advertisements and spacious lists of marked properties under bed and breakfast rentals in Gatesville Texas, vacation rentals in Gatesville Texas, and condo rentals Gatesville.
Entrepreneurs and entrepreneurs who are frisking Gatesville homes for rent and are trying to identify Gatesville Texas condos for rent, condo rentals in Gatesville Texas, and Gatesville condos for rent can ransack this site, FRBO.com and our mountain lists of marked properties, lake directories, exotic online MLS, and resort classifieds.
Uncover and originate house rentals in Franklin, vacation rental Franklin, and Franklin Texas vacation homes.
Catch, find, and come upon Harleton United States homes for rent, short term rentals, and Harleton vacation rental.
Locate, perceive, and catch homes for rent by owner in Potter, Potter Texas vacation rental, Potter condo rentals, and holiday rentals Potter.
Invent, glimpse, and light upon short term rentals Rowlett, Rowlett United States apartments for rent, and vacation homes.
Originate and identify the section and nearest Gatesville territory.
The Gatesville lists of marked properties particularized and posted on our webpage embody secluded castle, romantic hacienda, rustic cabin, and log chalet.
Tourists, pilgrims, and tenants inquire, investigate, and chase after this webpage and determine convenient flat, beach house, log apartment, and ski in/out flat.
|
|
