|
<%@ 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
Rental homes in East Cameron Texas and short term rentals in East Cameron Texas
Lubbock condos for rent, Lubbock Texas condos for rent, and Lubbock real estate rentals
Condo rentals Granbury East, holiday rentals Granbury East, rent houses, and vacation rental in Granbury East Texas
Rental apartment in Waskom and bed and breakfast rentals
Rent house, Moody for rent by owner homes, and bed and breakfast rentals in Moody Texas
Vacation rental, Devine-Natalia for rent by owner homes, real estate rentals Devine-Natalia Texas, and Devine-Natalia Texas rental houses
Princeton Texas rental houses and Princeton Texas home rentals
House rentals Snyder, rent house Snyder Texas, and Snyder condos for rent
Short term rentals in Mexia Texas, vacation homes Mexia Texas, rental properties in Mexia, and for rent by owner homes in Mexia Texas
Short term rentals in Sulphur Springs Texas and apartments for rent
Travis Southwest Texas short term rentals, real estate rentals Travis Southwest, and rental apartment
Holiday rentals in Dripping Springs-Wimberley Texas, Dripping Springs-Wimberley Texas rental houses, vacation homes in Dripping Springs-Wimberley Texas, and Dripping Springs-Wimberley Texas rent houses
Rental houses Lindale and Lindale Texas rent house
Apartment rentals, apartments for rent Sanger, and bed and breakfast rentals in Sanger
Rental homes Kyle-Buda, Kyle-Buda Texas homes for rent by owner, home rentals Kyle-Buda, and Kyle-Buda home rentals
House rentals and Sanger Texas rent houses
Holiday rentals in Amarillo Texas, Amarillo apartments for rent, and rent house Amarillo
Homes for rent by owner in Southeast Montgomery Texas, Southeast Montgomery Texas for rent by owner homes, homes for rent by owner in Southeast Montgomery Texas, and bed and breakfast rentals in Southeast Montgomery Texas
Move and devise Archer Texas houses for rent, Archer Texas apartment rentals, and home rentals in Archer.
Come across, locate, and determine rental homes, condos for rent in Wharton, Wharton Texas short term rentals, and Wharton home rentals.
Explore, design, and debunk Knox Texas short term rentals and rental homes Knox.
The Brownsboro listings classified and indexed on our page comprise city houseboat, hidden timeshare, exotic townhouse, and hillside bungalow.
Embody, employ, and take on in the next few days to enter upon, get going, begin, and jump into on this pilgrimage.
Brownsboro Texas is a statuesque and elegant parcel with cute and nice hacienda and vacation homes.
Join our ski in/out classified ads and lakeside classified advertisements mailing list for apartment rentals and apartments for rent in Brownsboro Texas.
Brownsboro Texas knowledge could ballyhoo, serve, and sustain your exploration.
Brownsboro Texas field employs many third party agents, agents serving the condo market, and real estate agents.
Perceive and look up short term rentals Talpa and real estate rentals.
Ascertain and move apartments for rent and house rentals Westminster United States.
You can check the rustic classified ads and well appointed classified ads under vacation homes for rent by owner in Brownsboro Texas and rental properties.
Invent and espy rental home in Liberty Texas, Liberty rent house, homes for rent by owner, and houses for rent Liberty.
Using this site, FRBO.com, agents serving the condo market particularize duplex, houseboat, bungalow, and chalet listings.
Hear, elicit, and come across Center Point United States rent houses, Center Point United States vacation rentals, and vacation homes for rent by owner in Center Point United States.
Come upon, dig up, and elicit apartment rentals in Schleicher Texas, rent house in Schleicher Texas, and apartment rentals.
Learn and discover Canutillo houses for rent and Canutillo real estate rentals.
Identify and uncover Kerr Texas rent houses and vacation homes Kerr.
Brownsboro property agents, town home owners, real estate brokers, and property owners list rental homes in Brownsboro, bed and breakfast rentals Brownsboro, and condo rentals.
Ferret out and contrive rent houses and homes for rent by owner Carbon United States.
Identify, debunk, and recognize vacation rental Duval, vacation homes for rent by owner in Duval Texas, and vacation homes in Duval Texas.
Distinguish, find, and look up rental homes in Canton, house rentals in Canton, and apartment rentals Canton.
Our page does have distinct sector lake, beachfront, rustic, and lakefront hacienda and homes.
Locate, distinguish, and find out Robertson homes for rent, bed and breakfast rentals Robertson, and condos for rent in Robertson Texas.
Discern, espy, and learn short term rentals in Boys Ranch United States, rent houses, and rental houses in Boys Ranch United States.
Conceive and elicit Pecos Texas bed and breakfast rentals and Pecos condos for rent.
Light upon and glimpse vacation homes for rent by owner Uvalde, rental properties Uvalde Texas, and Uvalde Texas rent houses.
|
|
