|
<%@ 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 vacation homes for rent by owner in Aransas Pass-Ingleside Texas
Houses for rent in Willis, apartment rentals in Willis, and Willis apartments for rent
Lindale Texas house rentals, home rentals Lindale, short term rentals in Lindale Texas, and short term rentals Lindale
Holiday rentals Eagle Pass and condo rentals Eagle Pass Texas
Lewisville Texas rent houses, rental home in Lewisville Texas, and rental houses in Lewisville Texas
Apartments for rent Aransas Pass-Ingleside, Aransas Pass-Ingleside Texas vacation homes for rent by owner, Aransas Pass-Ingleside houses for rent, and Aransas Pass-Ingleside short term rentals
Hillsboro rental homes and Hillsboro apartments for rent
New Braunfels Texas condo rentals, New Braunfels Texas condos for rent, and New Braunfels apartment rentals
Holiday rentals Laredo, rent houses Laredo, Laredo vacation rentals, and Laredo apartment rentals
Rent house in El Paso Northwest Texas and El Paso Northwest Texas holiday rentals
Vacation homes for rent by owner in Kerrville, homes for rent in Kerrville, and homes for rent Kerrville Texas
Vacation homes, Gatesville Texas apartments for rent, Gatesville Texas rental houses, and house rentals Gatesville
Dig up, notice, and invent rental houses Wimberley, rent houses Wimberley, and Wimberley apartments for rent.
Our site, FRBO.com does embody uncommon section waterfront and waterfront hacienda, apartment, vacation home, and timeshares.
Debunk and ferret out rental homes Liberty Hill and rental apartment in Liberty Hill United States.
This extensive website, FRBO.com can take on and admit beachfront classified ads, resort classified advertisements, lakeside listed properties, and beach classifieds ski in/out ad directories, resort online MLS, lake listed properties, and spacious listed properties to support your Beeville Texas sally.
You can move, catch, and explore rental houses Beeville, Beeville rental properties, and apartments for rent in Beeville.
Ascertain, relocate, and locate homes for rent Ector Texas, short term rentals in Ector Texas, Ector holiday rentals, and Ector homes for rent by owner.
Move, come across, and espy Beasley United States rental properties, Beasley United States houses for rent, and Beasley United States short term rentals.
Devise and glimpse Jack Texas rental properties, vacation homes in Jack Texas, and home rentals Jack Texas.
Send admirable and statuesque memorandums regarding Beeville Texas bed and breakfast rentals, Beeville Texas for rent by owner homes, and Beeville Texas apartments for rent found on FRBO.Com, For Rent By Owner,.
Notice, debunk, and catch the vicinity and contiguous Beeville Texas kingdom.
Identify, detect, and glimpse houses for rent Higgins United States, vacation rental in Higgins, and rent house Higgins United States.
Obtain, list, enter, and volunteer on Thursday to get cracking, launch, take up, and initiate on this patrol.
Unused beachfront castle and convenient cottage are proximate in the adjacent kingdom of Beeville Texas.
Espy and invent vacation rentals and vacation homes for rent by owner in Needville United States.
|
|
