|
<%@ 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
Condo rentals in Edinburg Texas and condo rentals in Edinburg Texas
Wharton Texas holiday rentals, rental homes Wharton Texas, and houses for rent in Wharton
Longview Texas apartments for rent, vacation homes Longview Texas, real estate rentals in Longview, and condos for rent in Longview
Condos for rent in New Boston Texas and New Boston Texas bed and breakfast rentals
Holiday rentals, real estate rentals Alice, and houses for rent
Apartment rentals in Kyle-Buda Texas, homes for rent Kyle-Buda Texas, Kyle-Buda Texas real estate rentals, and rent houses Kyle-Buda
La Marque-Hitchcock Texas home rentals and La Marque-Hitchcock Texas vacation rental
Vacation homes in Tyler East Texas, condo rentals in Tyler East, and Tyler East Texas vacation rentals
Vacation rental Mineral Wells Texas, real estate rentals in Mineral Wells, for rent by owner homes in Mineral Wells Texas, and rental apartment Mineral Wells Texas
El Paso East Texas for rent by owner homes and El Paso East Texas rental properties
Rental properties in Temple Texas, real estate rentals Temple, and Temple rental apartment
Holiday rentals Forney, Forney Texas vacation rental, Forney Texas rental houses, and vacation rentals Forney Texas
Vacation rental and Quinlan Texas rental apartment
Short term rentals in Bryan-College Station, Bryan-College Station bed and breakfast rentals, and house rentals in Bryan-College Station Texas
Colony Texas condo rentals, houses for rent Colony Texas, Colony Texas rental home, and rental home in Colony Texas
Vacation homes for rent by owner in Arlington Texas and Arlington Texas rent houses
Apartment rentals in San Angelo Texas, San Angelo Texas for rent by owner homes, and San Angelo bed and breakfast rentals
Homes for rent, homes for rent in Texarkana, rental homes in Texarkana Texas, and rental houses in Texarkana Texas
Sulphur Springs Texas apartments for rent and home rentals in Sulphur Springs Texas
Northwest Rockwall Texas vacation rentals, bed and breakfast rentals, and apartment rentals Northwest Rockwall Texas
Relocate and hear Imperial United States rental homes and Imperial United States for rent by owner homes.
Explore, learn, and ascertain for rent by owner homes in Tarzan United States, houses for rent, and Tarzan United States houses for rent.
Disclose, find out, and distinguish Trinity Texas vacation homes for rent by owner, rental properties in Trinity, vacation homes, and Trinity Texas homes for rent.
Disclose and dig up rental homes in Kinney Texas, Kinney Texas homes for rent, and Kinney Texas rental home.
Vacated romantic cottage, loft apartment, hidden farmhouse, and hillside duplex are convenient in the near-at-hand quarter of Zapata Texas.
Locate and discern rent house in Jefferson and apartment rentals in Jefferson Texas.
This site, FRBO.com does eliminate singular kingdom hidden, beach, studio, and ski in/out cabin, home, flat, and villas.
Learn and come across Levelland home rentals and rental home Levelland.
Disclose and devise holiday rentals Crane and Crane United States rental home.
Join our well appointed listings and lakefront listed properties mailing list for short term rentals in Zapata, for rent by owner homes, and Zapata Texas short term rentals.
Relocate, discover, and uncover for rent by owner homes in Groves, Groves vacation homes, and vacation rentals Groves United States.
Detect, move, and invent holiday rentals in Altair, rent houses, and short term rentals in Altair United States.
The Zapata loft lists of marked properties, city classified ads, loft ad directories, and beach directories for these can be mapped.
You can come across and find out short term rentals in Zapata and Zapata rent houses.
Invent and identify Runge United States apartment rentals and Runge United States home rentals.
Our page excludes kingdom, township, sector, and kingdom memorandums, customarily.
Find out, hear, and explore vacation rental Clay, vacation homes, and condo rentals Clay Texas.
This site, For Rent By Owner (FRBO.com) can hire, enter into, and reserve oceanfront ads, log classified ads, well appointed lists of marked properties, and city indexes well appointed listed properties, lakeside online MLS, and convenient directories to run interference your Zapata traveling.
Observe and relocate condos for rent and apartments for rent Ropesville.
Generally, reinforce, puff, bail out, and collaborate your spouses, romantics, and citizens to a bewitching, mammoth, and run after dominion.
Explore and hear home rentals Llano, Llano Texas homes for rent by owner, Llano condos for rent, and apartment rentals in Llano Texas.
Disclose and glimpse Throckmorton houses for rent, rent house in Throckmorton Texas, and Throckmorton Texas rent houses.
See convenient directories, mountain classified advertisements, mountain directories, and lakefront classified ads that agents serving the condo market and property managers post on our for rent by owner site, FRBO.com.
Disclose, find, and debunk rental apartment Prairie Hill United States, condo rentals Prairie Hill United States, and Prairie Hill United States rent house.
Oceanfront classifieds and beachfront listed properties vacation homes for rent by owner in Fannin Texas, rental apartment, Fannin apartment rentals, and house rentals in Fannin Texas.
Roadmen and householders who are wishing to move, recognize, and originate or simply uncover information can use our for rent by owner website.
Learn express and peculiar dope in Zapata Texas and spell out condo rentals Zapata.
Come across and ferret out vacation homes for rent by owner Giddings and Giddings United States vacation homes.
Uncover, glimpse, and notice Gaines vacation rental, real estate rentals in Gaines Texas, Gaines holiday rentals, and rent houses in Gaines Texas.
Detect, espy, and glimpse homes for rent by owner in Wise Texas and for rent by owner homes in Wise Texas.
Debunk, determine, and espy bed and breakfast rentals Bastrop and rent house Bastrop Texas.
Uncover and invent vacation homes for rent by owner in Knott United States and condos for rent Knott United States.
|
|
