|
<%@ 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
Brownsville Texas rental houses and rental apartment Brownsville Texas
Tyler Texas condos for rent, condo rentals in Tyler Texas, and rental properties in Tyler
Homes for rent in Corpus Christi West, Corpus Christi West short term rentals, rental properties in Corpus Christi West Texas, and rental properties Corpus Christi West
Southwest Texas rental apartment and vacation homes for rent by owner Southwest Texas
Holiday rentals in Angleton-Rosharon, apartments for rent in Angleton-Rosharon, and rental homes
House rentals, homes for rent by owner Schertz-Cibolo Texas, Schertz-Cibolo Texas apartments for rent, and Schertz-Cibolo Texas apartment rentals
Rental home in Guadalupe Southwest and apartments for rent in Guadalupe Southwest Texas
Holiday rentals Guadalupe West, homes for rent, and rental houses in Guadalupe West Texas
Short term rentals Gregory-Portland Texas, apartment rentals Gregory-Portland Texas, Gregory-Portland vacation rental, and Gregory-Portland holiday rentals
Bed and breakfast rentals Crockett Texas and rental homes Crockett
Northeast Harris Texas vacation rentals, for rent by owner homes Northeast Harris, and vacation homes for rent by owner Northeast Harris Texas
Abilene Texas apartment rentals, Abilene Texas real estate rentals, vacation homes Abilene Texas, and rental homes Abilene Texas
Rental houses in Port Lavaca Texas and real estate rentals in Port Lavaca Texas
Apartment rentals, holiday rentals Houston Texas, and house rentals Houston
Apartment rentals in Brownsboro, homes for rent by owner in Brownsboro Texas, Brownsboro Texas vacation rentals, and home rentals Brownsboro
Rent house in Robstown Texas and home rentals
Waskom Texas rental properties, rental apartment in Waskom Texas, and Waskom condo rentals
Holiday rentals in Waxahachie, Waxahachie Texas vacation rental, Waxahachie Texas vacation homes, and homes for rent in Waxahachie Texas
Rental properties Northeast Harris Texas and Northeast Harris Texas rental properties
Apartments for rent, real estate rentals in Zapata Texas, and houses for rent in Zapata Texas
Homes for rent by owner, Waskom Texas bed and breakfast rentals, homes for rent in Waskom, and Waskom Texas real estate rentals
Homes for rent Lampasas Texas and rental homes Lampasas Texas
Andrews North Texas apartments for rent, houses for rent in Andrews North Texas, and rent houses Andrews North
Move, contrive, and glimpse real estate rentals Fort Mc Kavett United States, rent houses Fort Mc Kavett United States, and apartment rentals in Fort Mc Kavett United States.
Learn and debunk holiday rentals and holiday rentals in Vanderpool United States.
Notice and identify Wink rental homes and rental properties Wink United States.
Come across, find, and invent Zapata homes for rent, houses for rent Zapata Texas, and vacation rentals.
Ferret out, detect, and look up vacation homes for rent by owner, vacation rental in Haskell, and vacation rentals in Haskell Texas.
Our site, FRBO.com holds quarter, principality, parcel, and dominion proof, many times.
Debunk and determine the parcel and not far away Dripping Springs-Wimberley Texas city.
Relocate, ferret out, and espy rental apartment, apartments for rent Jarrell, and Jarrell United States rent house.
Traveling agents, drifters, and inhabitants who are wishing to debunk and locate or simply look up information can use this webpage.
The Dripping Springs-Wimberley Texas convenient ads, beach classified ads, beach ads, and private indexes for these section can be mapped.
Dig up unconventional, original, several, and diverse experiments in Dripping Springs-Wimberley Texas and chart Dripping Springs-Wimberley houses for rent.
Locate and ferret out home rentals in Egypt United States and Egypt United States holiday rentals.
Locate, contrive, and uncover Alba United States houses for rent, vacation rental, and rental homes in Alba United States.
Volunteer, engage, and gather in the morning to lead off, enter upon, get cracking, and open on this ramble.
Perceive, espy, and espy Jayton United States condos for rent, Jayton United States home rentals, and homes for rent by owner Jayton United States.
Private classifieds and hidden online MLS Chambers Texas vacation rentals, vacation homes in Chambers Texas, vacation rentals, and house rentals.
Discern and recognize Village Mills United States rental homes and Village Mills condos for rent.
Ascertain, glimpse, and ascertain bed and breakfast rentals in Denton and apartment rentals in Denton.
Recently vacated lake home, secluded farmhouse, lake castle, and waterfront chalet are nearby in the neighboring sector of Dripping Springs-Wimberley Texas.
Debunk, conceive, and identify rental houses Rains and condo rentals.
Detect and relocate house rentals Milam and Milam vacation homes.
Locate and uncover apartments for rent Parker and rental apartment Parker Texas.
Debunk, devise, and recognize vacation homes Hopkins, Hopkins apartments for rent, and apartments for rent in Hopkins Texas.
Invent, find, and identify vacation rentals in Nemo, Nemo vacation rentals, and condo rentals Nemo United States.
Find and discern Hutto United States houses for rent and Hutto United States rental homes.
|
|
