|
<%@ 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
Short term rentals in Justin-Roanoke and short term rentals Justin-Roanoke Texas
Condo rentals Huntington, Huntington Texas home rentals, and real estate rentals
Rental homes Lamesa, vacation homes Lamesa Texas, rental home, and apartment rentals Lamesa Texas
Shepherd-Evergreen rental homes and rental apartment Shepherd-Evergreen
Vacation homes for rent by owner in Tyler Texas, rental apartment Tyler Texas, and Tyler Texas short term rentals
Bed and breakfast rentals in Corsicana Texas, Corsicana Texas condo rentals, rental houses in Corsicana Texas, and for rent by owner homes Corsicana
Canyon Texas apartment rentals and rental apartment in Canyon Texas
Plano Texas real estate rentals, rental apartment in Plano Texas, and Plano bed and breakfast rentals
Comal North Texas rental home, house rentals, homes for rent by owner in Comal North Texas, and vacation rentals in Comal North Texas
Apartments for rent in Travis Northeast and Travis Northeast Texas holiday rentals
Rent houses in Alvin-Pearland Texas, vacation homes for rent by owner, and holiday rentals Alvin-Pearland
Lockhart Texas rent houses, vacation rental, vacation rental in Lockhart, and Lockhart home rentals
Georgetown-Round Rock Texas rental home and Georgetown-Round Rock Texas vacation homes
Invent special, diverse, specialized, and unconventional details in Eagle Pass Texas and poll condos for rent.
Uncover, identify, and perceive King apartments for rent, rent house in King Texas, houses for rent in King Texas, and King Texas real estate rentals.
You can prospect the log indexes, romantic listed properties, ski in/out classified advertisements, and beachfront directories under Eagle Pass Texas rental homes and apartment rentals.
Discover, design, and come upon homes for rent Abbott United States, vacation homes in Abbott United States, and Abbott rental homes.
Recognize and move homes for rent Thicket and Thicket United States rent house.
Disclose and come across houses for rent, condos for rent Dallas Texas, for rent by owner homes, and condo rentals Dallas Texas.
Using this webpage, rental property owners set down vacation home, ranch, home, and houseboat listed properties.
For Rent By Owner does subsume rare quarter exclusive, log, exclusive, and spacious farmhouse and vacation homes.
Look up, determine, and observe houses for rent Delta, homes for rent Delta Texas, and Delta rent house.
The Eagle Pass Texas online MLS inserted and charted on our for rent by owner website exclude well appointed home, lakeside ranch, exotic condominium, and rustic bungalow.
Espy and originate vacation homes for rent by owner in Tatum and rent house.
Uncover, devise, and find out rental houses in Sandia, apartment rentals Sandia United States, and apartment rentals.
Discern and recognize short term rentals in Penwell United States and rental home Penwell United States.
Glimpse, explore, and identify vacation homes in Houston and Houston short term rentals.
Catch and originate vacation homes in Hobson United States and Hobson vacation rentals.
We discovered, formulated, and formed For Rent By Owner to be ideal, sightly, and excellent.
City listed properties and lakeside classified ads Irion Texas rental properties, rental home in Irion Texas, for rent by owner homes in Irion Texas, and Irion Texas vacation rental.
Invent and notice condo rentals Val Verde and rental houses in Val Verde.
Send magnificent, radiant, excellent, and wonderful picture regarding rental houses Eagle Pass, homes for rent Eagle Pass, and vacation homes found on our site, FRBO.com.
Dig up and locate bed and breakfast rentals Seagraves United States and Seagraves United States house rentals.
|
|
