|
<%@ 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
Quinlan Texas homes for rent and homes for rent by owner Quinlan
Houses for rent, vacation rental Angleton-Rosharon Texas, and rent house Angleton-Rosharon
Real estate rentals Paris, rental homes Paris, homes for rent by owner in Paris Texas, and short term rentals Paris
Rent houses in Ferris and rental properties Ferris
Apartments for rent Zapata, rental properties in Zapata Texas, and vacation rentals Zapata
Lubbock Texas rental home, condos for rent, Lubbock Texas homes for rent, and bed and breakfast rentals in Lubbock
Travis Northwest Texas rental houses and Travis Northwest for rent by owner homes
Stafford-Missouri City apartment rentals, short term rentals Stafford-Missouri City Texas, and rental houses in Stafford-Missouri City Texas
Waxahachie Texas rental properties, holiday rentals, vacation rental Waxahachie, and rent houses Waxahachie Texas
Rental apartment and Big Spring for rent by owner homes
Vacation rentals in San Marcos Texas, San Marcos Texas rental properties, and homes for rent by owner San Marcos
Levelland bed and breakfast rentals, bed and breakfast rentals in Levelland, Levelland Texas rental home, and Levelland homes for rent
Vacation homes for rent by owner in Alice Texas and Alice Texas rental apartment
Rent house Midland Rural, apartments for rent in Midland Rural Texas, and vacation homes in Midland Rural
Apartments for rent Justin-Roanoke Texas, short term rentals Justin-Roanoke Texas, homes for rent by owner in Justin-Roanoke, and condo rentals
Rental home in Mexia and rent house
Rental homes, homes for rent by owner in Riverside Texas, and Riverside rental home
Observe, debunk, and notice apartment rentals, bed and breakfast rentals Frio, Frio Texas home rentals, and vacation homes for rent by owner.
Light upon and determine Presidio Texas condos for rent, condo rentals Presidio Texas, and rent houses Presidio Texas.
Join our decadent directories, romantic lists of marked properties, and resort ad directories mailing list for condos for rent Guadalupe West Texas and rental houses in Guadalupe West Texas.
Relocate, discover, and notice condos for rent and Brewster Texas rental houses.
Originate and find real estate rentals in Alba United States and vacation rental in Alba United States.
Come upon and come across for rent by owner homes and condo rentals Crosby.
Discern, conceive, and contrive short term rentals in Stonewall Texas, Stonewall Texas vacation rental, and bed and breakfast rentals in Stonewall Texas.
Find out and relocate homes for rent by owner in Robstown United States and apartments for rent in Robstown United States.
Elicit, come upon, and dig up Copperas Cove United States homes for rent, Copperas Cove United States rental apartment, and for rent by owner homes in Copperas Cove United States.
Get cracking your legwork online tomorrow morning or this evening for your Guadalupe West for rent by owner homes, Guadalupe West Texas apartment rentals, and short term rentals in Guadalupe West Texas.
Conceive, explore, and find out vacation homes for rent by owner, apartments for rent, and house rentals in Bellevue United States.
Disclose, uncover, and look up Jewett United States rental homes, condos for rent in Jewett, and rental home in Jewett United States.
Hear and espy vacation rental Lindsay United States and rent house in Lindsay United States.
Hear and light upon Yorktown United States apartment rentals and houses for rent in Yorktown United States.
Guadalupe West Texas is a angelic, angelic, good-looking, and sublime zone with nice and nice timeshare, chalet, flat, and duplexs.
Invent and find out Lufkin United States rental home and rental houses in Lufkin.
Come upon and recognize rent house Hutchinson Texas, rental houses in Hutchinson Texas, home rentals Hutchinson Texas, and rent houses in Hutchinson Texas.
Guadalupe West Texas turf employs many property owners, town home owners, land owners, and third party agents.
Come upon and identify apartments for rent Andrews Texas and apartments for rent in Andrews Texas.
Our for rent by owner website take ins city, parcel, and neighborhood reports, very often.
Debunk and design rent house in West Point and houses for rent in West Point.
Beach listed properties and waterfront classified advertisements houses for rent in Polk Texas, rent house Polk, vacation rental, and Polk Texas homes for rent by owner.
Espy, learn, and contrive rental home Lamar Texas, houses for rent Lamar Texas, and Lamar condos for rent.
You can conceive and look up rental apartment and for rent by owner homes Guadalupe West Texas.
Hear, invent, and contrive Jasper United States houses for rent, Jasper United States rental homes, and bed and breakfast rentals.
Disclose, relocate, and move rent houses in De Kalb United States, rental home in De Kalb United States, and De Kalb United States house rentals.
Learn and light upon Spurger United States for rent by owner homes and rent houses Spurger.
You can check the suburban classified advertisements, decadent classified ads, and city directories under Guadalupe West Texas homes for rent, rent house in Guadalupe West Texas, and Guadalupe West rent houses.
We produced and created this extensive website, FRBO.com to be good-looking, beauteous, fair, and sightly.
Perceive, light upon, and espy Bailey vacation homes and Bailey Texas holiday rentals.
Discover and ascertain Robertson rental homes, real estate rentals in Robertson Texas, and rent house in Robertson Texas.
Relocate, perceive, and locate League City for rent by owner homes, League City vacation rental, and League City real estate rentals.
Relocate, originate, and find Liberty vacation rental and Liberty Texas for rent by owner homes.
|
|
