|
<%@ 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
Wharton apartment rentals and homes for rent Wharton
Condo rentals, rental properties Northwest Harris Texas, and Northwest Harris Texas apartments for rent
Rockport Texas vacation homes for rent by owner, vacation homes for rent by owner in Rockport Texas, vacation rental, and for rent by owner homes Rockport Texas
Rent houses in Laredo and Laredo Texas vacation homes
Seguin Texas home rentals, Seguin Texas rental home, and vacation homes for rent by owner in Seguin
Condos for rent in Terrell South Texas, rental apartment, Terrell South Texas apartments for rent, and condos for rent in Terrell South Texas
Pittsburg Texas for rent by owner homes and short term rentals in Pittsburg Texas
Holiday rentals in Paris Texas, rent house, and Paris Texas for rent by owner homes
Bed and breakfast rentals Colony Texas, rent house Colony Texas, rental houses Colony, and Colony Texas real estate rentals
Apartment rentals in Houston and rent house in Houston Texas
Real estate rentals in Del Rio, rental houses in Del Rio Texas, and for rent by owner homes Del Rio Texas
Condos for rent in Bridge City-Orangefield Texas, Bridge City-Orangefield Texas bed and breakfast rentals, short term rentals in Bridge City-Orangefield, and homes for rent in Bridge City-Orangefield
Catch, find out, and elicit Lott United States condos for rent, Lott United States holiday rentals, and rental home in Lott United States.
Boerne Texas details could relieve and work with your exploration.
Traveling saleswomen and trippers explore, go through, and beat about our for rent by owner website and originate romantic home and decadent vacation home.
Invent and determine apartment rentals in Reagan Texas, Reagan Texas vacation homes, and apartment rentals.
Empty city vacation home, lakefront castle, resort flat, and lake apartment are contiguous in the adjoining sector of Boerne Texas.
Conceive and perceive the stretch and not faraway Boerne Texas square.
Boerne is a appealing, wonderful, and classy precinct with symmetrical, refined, and shapely villa and cabins.
Join our lakefront classified ads, exclusive listings, and oceanfront listings mailing list for Boerne vacation homes and vacation rental Boerne Texas.
Recognize, design, and observe Hopkins homes for rent and Hopkins Texas short term rentals.
You can catch and locate condo rentals Boerne Texas, for rent by owner homes Boerne Texas, and homes for rent Boerne Texas.
Determine and recognize vacation homes for rent by owner and rent houses New London United States.
Our for rent by owner website does involve unusual log, log, and decadent house and cabins.
This webpage can procure, get, attract, and sign on penthouse classified advertisements and secluded directories resort indexes, spacious lists of marked properties, and oceanfront lists of marked properties to plug your Boerne jaunt.
Invent, relocate, and catch short term rentals Seguin United States, for rent by owner homes in Seguin United States, and vacation rental.
Detect, observe, and conceive vacation homes in Camp Texas, apartments for rent Camp Texas, for rent by owner homes Camp Texas, and home rentals in Camp Texas.
Devise, discover, and come upon bed and breakfast rentals, rental houses Newton, and Newton Texas rent houses.
Perceive another and singular figures in Boerne and particularize apartments for rent in Boerne.
Our online website, FRBO.com encloses turf, quarter, and plot compilations, not infrequently.
Boerne state employs many rental owners, third party listing companies, and home owners.
Learn and discern Dimmit Texas bed and breakfast rentals, Dimmit holiday rentals, and rental properties.
|
|
