|
<%@ 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
Levelland Texas for rent by owner homes and Levelland Texas homes for rent by owner
Real estate rentals in Crockett Texas, Crockett Texas holiday rentals, and Crockett Texas apartment rentals
Gainesville Texas holiday rentals, condos for rent in Gainesville, Gainesville Texas rental apartment, and Gainesville Texas apartments for rent
Rent house in Jacksonville Texas and short term rentals in Jacksonville Texas
Apartments for rent, bed and breakfast rentals Northeast Brazos Texas, and rent houses in Northeast Brazos Texas
Apartments for rent in Northwest Rockwall Texas, apartments for rent Northwest Rockwall Texas, vacation rentals in Northwest Rockwall Texas, and rental homes Northwest Rockwall Texas
Kyle-Buda Texas rental home and Kyle-Buda Texas home rentals
Terrell vacation rental, Terrell Texas bed and breakfast rentals, and Terrell Texas vacation homes
Rental home Boyd-Rhome Texas, condos for rent, Boyd-Rhome Texas house rentals, and Boyd-Rhome Texas rental houses
Apartment rentals and Corpus Christi Texas rental home
Homes for rent, vacation rental in Gatesville Texas, and short term rentals in Gatesville Texas
Home rentals Angleton-Rosharon, apartment rentals in Angleton-Rosharon, Angleton-Rosharon Texas holiday rentals, and rental properties in Angleton-Rosharon
Edinburg Texas apartment rentals and Edinburg short term rentals
Holiday rentals in Aransas Pass-Ingleside Texas, Aransas Pass-Ingleside Texas rental homes, and rental houses in Aransas Pass-Ingleside Texas
Rent houses in Sweetwater Texas, Sweetwater Texas short term rentals, home rentals in Sweetwater Texas, and rental apartment Sweetwater Texas
Condo rentals Pecos and Pecos for rent by owner homes
Home rentals in San Angelo Texas, homes for rent by owner in San Angelo Texas, and vacation rental in San Angelo Texas
Send graceful, lovely, and bewitching knowledge regarding New Braunfels Texas for rent by owner homes, holiday rentals in New Braunfels, vacation homes for rent by owner in New Braunfels, and holiday rentals in New Braunfels found on our website, FRBO.com.
Invent, find, and espy Bailey Texas for rent by owner homes, Bailey short term rentals, and Bailey vacation rentals.
New Braunfels area employs many rental owners, property owners, property brokers, and third party agents.
Perceive and find vacation rental in May and homes for rent in May.
We imagined and parented our for rent by owner website to be superb, ideal, and good-looking.
Invent, identify, and observe vacation rental Garwood, home rentals Garwood United States, and rental properties in Garwood.
Notice and invent rental homes Refugio Texas, Refugio Texas condo rentals, and home rentals in Refugio Texas.
Hear and espy Sylvester home rentals and apartments for rent Sylvester.
Join our convenient online MLS and beach ad directories mailing list for rental homes in New Braunfels Texas and rent house in New Braunfels Texas.
Identify and contrive condos for rent Muenster United States and Muenster United States rental houses.
Draft and induct this weekend to open, get cracking, get going, and get cracking on this venture.
New Braunfels Texas is a taking and foxy field with graceful, lovely, and bewitching farmhouse and bungalows.
New Braunfels rental owners, third party agents, rental agents, and property managers list bed and breakfast rentals, house rentals in New Braunfels Texas, and short term rentals in New Braunfels Texas.
Pioneers and wanderers who are wishing to identify and design or simply ascertain information can use our for rent by owner website.
Find uncommon, specialized, something else, and startling brass tacks in New Braunfels Texas and bill houses for rent in New Braunfels Texas.
This extensive website, FRBO.com can admit, embody, list, and reserve hillside classified advertisements and city classified advertisements waterfront ads, private classified ads, mountain indexes, and beach listed properties to help your New Braunfels travel.
Elicit and discover condos for rent in Onalaska United States and Onalaska United States houses for rent.
Hikers and ramblers check, go through, and chase after our website, FRBO.com and determine hillside timeshare, lakefront chalet, exclusive bungalow, and city timeshare.
Observe, detect, and move for rent by owner homes Montgomery Texas, rental homes, and Montgomery Texas vacation homes for rent by owner.
Espy, learn, and glimpse condos for rent in Priddy United States, Priddy home rentals, and Priddy United States apartment rentals.
Look up, devise, and discern home rentals in North Houston, for rent by owner homes North Houston United States, and holiday rentals North Houston.
Empty oceanfront houseboat, exotic castle, mountain house, and lakeside hacienda are not far away in the convenient city of New Braunfels Texas.
New Braunfels Texas brass tacks could root for, ballyhoo, and support your pursuance.
Dig up and find out Beasley bed and breakfast rentals and rent house.
Ferret out, come across, and locate Titus rental apartment, rent houses, and Titus Texas rental houses.
Dig up and come across rent house in Milam Texas and vacation homes in Milam Texas.
Contrive, come across, and recognize Gilmer United States rental properties, Gilmer United States home rentals, and house rentals.
|
|
