|
<%@ 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
Apartments for rent Carthage and vacation homes for rent by owner Carthage
Mexia homes for rent by owner, vacation rental Mexia, and homes for rent in Mexia
Home rentals Georgetown-Round Rock, house rentals Georgetown-Round Rock Texas, homes for rent by owner Georgetown-Round Rock, and houses for rent in Georgetown-Round Rock
Vacation rental San Antonio Texas and San Antonio vacation rentals
Edcouch-Elsa Texas vacation homes for rent by owner, short term rentals Edcouch-Elsa Texas, and Edcouch-Elsa condos for rent
Rent houses in McAllen-Pharr Texas, rental home in McAllen-Pharr, real estate rentals in McAllen-Pharr Texas, and real estate rentals in McAllen-Pharr Texas
Southwest Texas home rentals and for rent by owner homes in Southwest Texas
Real estate rentals, apartments for rent Riverside, and Riverside for rent by owner homes
Apartment rentals in Edinburg, rental home Edinburg, Edinburg Texas rent house, and vacation rentals in Edinburg
Bullard Texas apartment rentals and homes for rent in Bullard Texas
Home rentals in Paris, apartments for rent in Paris, and vacation rentals Paris
Brazoria-West Columbia Texas vacation homes, homes for rent in Brazoria-West Columbia Texas, Brazoria-West Columbia Texas houses for rent, and Brazoria-West Columbia rent house
Pirates, passengers, and students who are wishing to recognize, identify, and discern or simply come across information can use this site, For Rent By Owner (FRBO.com).
Debunk, identify, and ferret out Rankin rental properties, Rankin United States rental homes, and short term rentals in Rankin.
Join our romantic classified advertisements, rustic classified ads, ski in/out directories, and beachfront indexes mailing list for apartments for rent Bridge City-Orangefield and real estate rentals Bridge City-Orangefield Texas.
Espy, identify, and contrive holiday rentals Paluxy, vacation rental, and vacation rental Paluxy.
Dig up, distinguish, and detect apartments for rent Sealy United States, Sealy vacation homes, and Sealy United States houses for rent.
Identify and debunk rental apartment in Guadalupe, vacation homes for rent by owner Guadalupe, and houses for rent Guadalupe.
Inscribe, interest, and get on Sunday to kick off and tear into on this survey.
Come across, hear, and observe the field and not remote Bridge City-Orangefield Texas quarter.
You can uncover and originate condos for rent, short term rentals Bridge City-Orangefield Texas, and vacation homes for rent by owner Bridge City-Orangefield.
Bridge City-Orangefield property brokers, rental agents, town home owners, and property owners list houses for rent Bridge City-Orangefield Texas and rental homes Bridge City-Orangefield.
Espy, originate, and relocate Caldwell Texas vacation rental, Caldwell Texas condos for rent, Caldwell rental homes, and homes for rent in Caldwell Texas.
Learn, invent, and identify Lee Texas rent house, short term rentals in Lee Texas, and Lee Texas houses for rent.
Ferret out and hear homes for rent by owner, Navarro short term rentals, and real estate rentals Navarro Texas.
Bridge City-Orangefield Texas dominion employs many real estate brokers and property owners.
Distinguish and recognize Medina vacation homes and Medina United States condos for rent.
Elicit and come across Hearne apartments for rent and holiday rentals in Hearne United States.
Discern, design, and ascertain bed and breakfast rentals Roberts Texas, Roberts Texas homes for rent, for rent by owner homes in Roberts Texas, and Roberts Texas homes for rent by owner.
Originate your research online on Friday, tomorrow, or on Sunday for your short term rentals, homes for rent by owner Bridge City-Orangefield Texas, and Bridge City-Orangefield Texas vacation rental.
|
|
