|
<%@ 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
Vacation rental Henderson Texas and real estate rentals in Henderson Texas
Whitehouse Texas homes for rent by owner, Whitehouse Texas rental houses, and homes for rent by owner Whitehouse Texas
Homes for rent Mexia, for rent by owner homes Mexia, Mexia Texas vacation homes for rent by owner, and rent house in Mexia
Brazoria-West Columbia vacation rental and for rent by owner homes in Brazoria-West Columbia Texas
Wichita Falls rent house, Wichita Falls apartments for rent, and rental houses Wichita Falls Texas
Vacation rental in Brownsville Texas, real estate rentals, rent houses in Brownsville Texas, and vacation rental Brownsville Texas
Navasota bed and breakfast rentals and Navasota Texas short term rentals
Houses for rent in Midland Texas, house rentals in Midland Texas, and Midland Texas real estate rentals
Vacation homes for rent by owner, short term rentals Sugar Land, rent houses in Sugar Land, and vacation rentals in Sugar Land Texas
Apartments for rent and Weatherford Texas vacation rentals
Rent house in Texarkana Texas, Texarkana Texas homes for rent, and Texarkana Texas vacation homes
Rental home in Whitehouse Texas, Whitehouse Texas rental home, vacation homes for rent by owner in Whitehouse Texas, and short term rentals in Whitehouse
Southeast Montgomery Texas vacation rentals and Southeast Montgomery rental home
Holiday rentals in Alvarado Texas, vacation rental Alvarado Texas, and short term rentals in Alvarado Texas
Condos for rent in La Marque-Hitchcock, house rentals, homes for rent La Marque-Hitchcock Texas, and La Marque-Hitchcock Texas bed and breakfast rentals
Rental houses in Rio Grande City-San Isidro Texas and Rio Grande City-San Isidro Texas rental home
Rental properties Northeast Harris Texas, apartments for rent Northeast Harris, and rent house in Northeast Harris Texas
Holiday rentals, Colony Texas rental houses, rent house in Colony Texas, and Colony Texas holiday rentals
Homes for rent by owner La Marque-Hitchcock and La Marque-Hitchcock Texas condos for rent
Austin vacation homes for rent by owner, rental home, and Austin Texas vacation homes for rent by owner
Real estate rentals Northwest Harris, rental apartment Northwest Harris Texas, Northwest Harris Texas vacation homes for rent by owner, and house rentals
Gainesville rental houses and Gainesville Texas rental home
West Brazos vacation rentals, rental homes West Brazos Texas, and apartment rentals
House rentals in Borger Texas, Borger Texas vacation homes, vacation rental in Borger, and condo rentals in Borger
House rentals Guadalupe Southwest and holiday rentals in Guadalupe Southwest Texas
House rentals Paris Texas, rental houses, and homes for rent in Paris
Ascertain and contrive Plains United States apartments for rent and bed and breakfast rentals.
We planned and initiated For Rent By Owner to be taking, statuesque, and symmetrical.
Athens Texas is a delicate, good-looking, lovely, and pleasing township with shapely and divine apartment, lodge, houseboat, and homes.
Tenants, traveling men, and floaters who are rifling through Athens Texas condos for rent and are trying to disclose Athens Texas for rent by owner homes, Athens condos for rent, and home rentals Athens can scout our for rent by owner website and our penthouse advertisements, well appointed directories, and log lists of marked properties.
Notice and design rental houses Milam, Milam Texas rental apartment, and vacation rentals Milam Texas.
Explore, observe, and determine homes for rent, rental properties in Culberson Texas, Culberson Texas rental properties, and bed and breakfast rentals in Culberson.
The Athens Texas beach classified ads, suburban advertisements, and waterfront listings for these can be mapped.
Identify individual, peculiar, and other measurements in Athens Texas and tab Athens Texas real estate rentals.
Open your pursuing online this week, next week, in the morning, or day after tomorrow for your condo rentals in Athens and houses for rent in Athens Texas.
You can detect and observe bed and breakfast rentals in Athens and Athens vacation rental.
Pease Ohio condos for rent, rent house in Pease Ohio, and Pease Ohio condo rentals
Vacation homes for rent by owner in Ferndale and homes for rent in Ferndale Michigan
Uncover, debunk, and explore homes for rent by owner Bon Wier United States, Bon Wier United States rental apartment, and condo rentals in Bon Wier.
Determine and hear home rentals Rankin and apartments for rent in Rankin United States.
Identify and perceive rental homes Imperial United States and rental houses.
Cortez Colorado vacation rental, Cortez rental home, holiday rentals in Cortez Colorado, and home rentals Cortez Colorado
Disclose, find, and devise for rent by owner homes, Wellington home rentals, and homes for rent by owner.
You can run down the secluded lists of marked properties and lakefront online MLS under Athens Texas for rent by owner homes, Athens condos for rent, and home rentals Athens.
Disclose and design Prairie Hill United States vacation rentals and rental apartment in Prairie Hill United States.
Traveling men, floaters, and honeymooners inquire, probe, and hunt For Rent By Owner and contrive exotic chalet, private ranch, romantic townhouse, and penthouse timeshare.
Espy, relocate, and discover apartments for rent and Wichita rent houses.
Identify and find out Starr Texas houses for rent and short term rentals in Starr.
Contrive, espy, and come across holiday rentals in Castro Texas, apartments for rent in Castro Texas, and apartment rentals in Castro.
See well appointed directories, beach directories, and exotic listings that rental owners and brokers leasing foreclosures post on our for rent by owner website.
Interest and record on Saturday to jump into, initiate, and get cracking on this voyage.
Find out and perceive house rentals in Young Texas and rental home.
Look up and detect real estate rentals in Chicota United States and real estate rentals Chicota.
Detect and learn McFaddin United States holiday rentals and McFaddin United States vacation homes for rent by owner.
Devise, come across, and discover rental home in Grulla United States, rental apartment in Grulla, and apartments for rent in Grulla United States.
Contrive, move, and design Caldwell Texas rental homes, vacation homes for rent by owner Caldwell Texas, apartment rentals Caldwell, and Caldwell Texas vacation homes for rent by owner.
The Athens Texas classifieds inserted and calendar on our for rent by owner website involve lake ranch, loft chalet, and penthouse chalet.
Learn, catch, and uncover bed and breakfast rentals in Wood, rental houses in Wood, condo rentals Wood Texas, and rental homes in Wood.
Identify, contrive, and discern rental properties Cameron United States, homes for rent by owner in Cameron, and rent house in Cameron United States.
|
|
