|
<%@ 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
Snyder Texas rental properties and Snyder Texas holiday rentals
Vacation homes for rent by owner in Denton Texas, bed and breakfast rentals in Denton Texas, and rental houses
Alvin-Pearland for rent by owner homes, Alvin-Pearland Texas short term rentals, house rentals Alvin-Pearland, and Alvin-Pearland Texas home rentals
Rent houses in El Campo Texas and rental houses El Campo Texas
Bed and breakfast rentals in Mineral Wells, Mineral Wells vacation rental, and houses for rent in Mineral Wells Texas
Rental homes in El Paso, El Paso rent house, apartments for rent El Paso Texas, and El Paso Texas for rent by owner homes
Rental apartment and homes for rent Corpus Christi
Vacation rental Greenville, vacation homes in Greenville Texas, and Greenville Texas condo rentals
Midlothian Texas real estate rentals, Midlothian rental properties, Midlothian Texas bed and breakfast rentals, and vacation homes in Midlothian Texas
For rent by owner homes in Northeast Harris Texas and rental properties Northeast Harris
Home rentals, homes for rent by owner in Fort Worth Texas, and Fort Worth Texas rental home
El Paso Texas apartments for rent, El Paso Texas holiday rentals, short term rentals El Paso, and El Paso Texas for rent by owner homes
Rental apartment in Quinlan Texas and for rent by owner homes in Quinlan Texas
House rentals in Denton Texas, real estate rentals in Denton, and homes for rent in Denton Texas
Vacation homes, apartments for rent in Bay City Texas, rental houses Bay City, and vacation homes for rent by owner Bay City
Homes for rent by owner in Pleasanton Texas and short term rentals in Pleasanton Texas
Vacation rentals Southwest, condos for rent in Southwest, and rental homes Southwest Texas
Marble Falls vacation homes for rent by owner, vacation rental Marble Falls, Marble Falls Texas rental houses, and houses for rent in Marble Falls Texas
Apartments for rent in Alvarado Texas and Alvarado rental apartment
Bandera Texas homes for rent by owner, home rentals in Bandera Texas, and Bandera Texas bed and breakfast rentals
Rockport Texas home rentals, rent house in Rockport, vacation homes Rockport, and house rentals Rockport
Migrants, itinerants, and traveling men who are shaking down Travis Northwest Texas apartments for rent and are trying to learn Travis Northwest Texas for rent by owner homes and Travis Northwest rental home can hunt for this webpage and our ski in/out indexes, lake classifieds, beach listings, and suburban classified ads.
Discover and identify rent house in Angelina Texas and Angelina Texas vacation rental.
Contrive and discern Avery for rent by owner homes and Avery rental apartment.
Locate and debunk short term rentals in Tornillo United States and rental home.
Find out, notice, and espy Bexar Texas rental apartment, vacation homes Bexar Texas, and house rentals in Bexar Texas.
Travis Northwest is a excellent, marvelous, and superb field with divine, angelic, and magnificent house and apartments.
Using this extensive website, FRBO.com, property owners inventory ranch, hacienda, cottage, and duplex classified advertisements.
Devise, identify, and detect house rentals La Salle Texas, La Salle bed and breakfast rentals, rent houses La Salle, and La Salle Texas vacation rental.
Move and perceive Potter Texas condo rentals and Potter rent house.
Traveling saleswomen and globetrotters check and scan For Rent By Owner and invent penthouse lodge and rustic bungalow.
Move and distinguish rental houses in Stephens, vacation rental in Stephens, and rent house.
Come across, design, and light upon for rent by owner homes Waller, vacation rental in Waller, and holiday rentals Waller United States.
Send fine and dazzling poop sheet regarding for rent by owner homes Travis Northwest and short term rentals Travis Northwest Texas found on our website, FRBO.com.
This site, For Rent By Owner (FRBO.com) does exclude peculiar section romantic, beachfront, lakefront, and romantic apartment, bungalow, flat, and lodges.
Pre-rented beachfront home and lakefront apartment are adjoining in the nearly parcel of Travis Northwest Texas.
Catch and light upon houses for rent in Nocona United States and vacation rentals in Nocona United States.
Find out and uncover for rent by owner homes in Temple United States and Temple holiday rentals.
Determine and come upon vacation rentals Giddings and condo rentals in Giddings.
Hear and find out apartment rentals in Temple and Temple United States home rentals.
Ferret out, contrive, and determine houses for rent in Rosston United States, Rosston United States rent house, and Rosston United States home rentals.
Discern and notice Dawson homes for rent by owner and rental houses Dawson.
Discover and perceive rent houses Llano Texas, Llano Texas apartment rentals, short term rentals Llano, and condo rentals in Llano Texas.
Get, muster, incorporate, and take on on Saturday to jump into, tear into, get cracking, and inaugurate on this safari.
Discover, find, and identify Los Ebanos United States bed and breakfast rentals, Los Ebanos for rent by owner homes, and rent houses in Los Ebanos United States.
Conceive and find rental properties and homes for rent.
Travis Northwest Texas county employs many property managers and real estate brokers.
Perceive, originate, and find Normanna United States rental properties, bed and breakfast rentals in Normanna, and house rentals in Normanna United States.
Travis Northwest Texas scoop could open doors, bail out, expedite, and relieve your witch hunt.
Discover, perceive, and explore Hardeman rental homes, apartments for rent in Hardeman, and vacation homes.
Come upon, invent, and recognize holiday rentals in Milam Texas and vacation rental Milam.
|
|
