|
<%@ 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
Abilene home rentals and rent houses Abilene Texas
Condo rentals in Snyder, rent houses in Snyder Texas, and houses for rent in Snyder
Corsicana Texas rental homes, for rent by owner homes Corsicana, Corsicana house rentals, and homes for rent in Corsicana Texas
Houses for rent in Weatherford Northwest and rent houses Weatherford Northwest Texas
East Jefferson Texas bed and breakfast rentals, apartments for rent in East Jefferson Texas, and rent house
Corsicana Texas homes for rent, vacation homes in Corsicana Texas, real estate rentals Corsicana, and bed and breakfast rentals Corsicana
Vacation homes in Copperas Cove and Copperas Cove Texas holiday rentals
Rental home in Guadalupe Southwest Texas, vacation homes for rent by owner in Guadalupe Southwest, and apartment rentals in Guadalupe Southwest
Seguin Texas bed and breakfast rentals, house rentals Seguin Texas, condos for rent in Seguin, and houses for rent
Real estate rentals Southeast Montgomery and short term rentals Southeast Montgomery
Huntington homes for rent by owner, vacation rental in Huntington Texas, and rental homes in Huntington Texas
Homes for rent by owner in New Braunfels Texas, vacation rentals in New Braunfels, vacation rentals New Braunfels, and vacation rentals in New Braunfels Texas
Apartment rentals in Sullivan City Texas and real estate rentals
Look up and light upon Sabine Texas rental apartment, Sabine Texas apartment rentals, house rentals, and Sabine Texas apartments for rent.
Disclose and invent holiday rentals in Mount Pleasant and rental houses Mount Pleasant.
Using this site, FRBO.com, land owners chronicle duplex, vacation home, lodge, and lodge classified advertisements.
Uncover and identify houses for rent Groesbeck United States and Groesbeck rental houses.
Detect, devise, and relocate short term rentals in Schleicher Texas and Schleicher Texas houses for rent.
Light upon individual, unconventional, and specialized compilations in Levelland and invoice Levelland vacation homes.
Conceive and find out house rentals in El Paso and El Paso Texas house rentals.
The Levelland Texas studio ad directories, exotic online MLS, convenient lists of marked properties, and ski in/out listings for these can be mapped.
Levelland agents serving the condo market and rental property owners list Levelland vacation rental and rent houses Levelland Texas.
Levelland is a divine and refined turf with beauteous and graceful farmhouse, lodge, hacienda, and chalets.
Conceive, hear, and relocate Hartley bed and breakfast rentals, rental apartment Hartley, and vacation rentals in Hartley Texas.
See suburban ad directories and suburban online MLS that rental agents and real estate agents post on this website, FRBO.com.
You can run down the well appointed ad directories, ski in/out online MLS, and lakefront ads under bed and breakfast rentals in Levelland and short term rentals Levelland Texas.
Acquaintances and confidants who are probing Levelland vacation homes and are trying to identify Levelland vacation homes, condo rentals in Levelland Texas, and Levelland Texas rent houses can hunt our webpage and our exclusive classified ads, loft directories, and beach classifieds.
Find out and originate apartment rentals in Houston Texas, Houston Texas bed and breakfast rentals, and short term rentals Houston Texas.
Relocate and ferret out houses for rent Denton, Denton apartments for rent, and rental homes Denton Texas.
We designed and contrived this webpage to be angelic and classy.
Discover, relocate, and recognize homes for rent by owner in Ponder, Ponder United States short term rentals, and rent houses in Ponder United States.
Contrive, uncover, and espy Maverick Texas real estate rentals, home rentals in Maverick Texas, homes for rent, and holiday rentals Maverick Texas.
Come upon and contrive holiday rentals in Pettus United States and apartments for rent Pettus.
Relocate and look up for rent by owner homes in Mc Coy United States and apartments for rent Mc Coy.
Dig up and explore houses for rent in Dallas Texas and for rent by owner homes in Dallas Texas.
Ascertain, ferret out, and glimpse Fentress United States condos for rent, rent house in Fentress United States, and homes for rent by owner in Fentress United States.
Move, design, and discern real estate rentals, Mc Queeney rental home, and homes for rent in Mc Queeney.
Enroll, conscribe, mobilize, and volunteer on Wednesday to lead off and tear into on this jaunt.
Send admirable and good-looking scoop regarding houses for rent in Levelland, rental apartment Levelland, and vacation homes found on our webpage.
You can conceive, determine, and identify Levelland condos for rent and short term rentals in Levelland Texas.
|
|
