|
<%@ 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
Real estate rentals and condo rentals Ferris Texas
Rental houses in Greenville Texas, rental apartment Greenville, and Greenville Texas rent house
Rental home, apartments for rent in Brownwood Texas, home rentals in Brownwood Texas, and rental houses in Brownwood Texas
Goldsmith-Penwell Texas rental properties and condos for rent in Goldsmith-Penwell
Rent houses in Castroville-LaCoste, Castroville-LaCoste Texas real estate rentals, and home rentals in Castroville-LaCoste Texas
Apartment rentals Huntsville Texas, Huntsville Texas vacation homes, vacation homes for rent by owner in Huntsville, and condo rentals Huntsville Texas
Rosenberg-Richmond rental homes and houses for rent Rosenberg-Richmond Texas
Homes for rent in Northwest Grayson Texas, Northwest Grayson bed and breakfast rentals, and rental houses in Northwest Grayson Texas
Rental apartment in Edcouch-Elsa Texas, rental properties in Edcouch-Elsa Texas, homes for rent in Edcouch-Elsa, and vacation homes for rent by owner in Edcouch-Elsa Texas
Houses for rent in Hallsville Texas and apartments for rent in Hallsville Texas
Home rentals in Navasota, home rentals in Navasota, and apartments for rent in Navasota
Fort Hood Texas rental apartment, Fort Hood Texas houses for rent, apartment rentals Fort Hood, and Fort Hood Texas vacation homes for rent by owner
Rent houses Pampa and vacation rental Pampa
Short term rentals, Burleson-Joshua rental houses, and rent house in Burleson-Joshua Texas
Rental homes Bryan-College Station, apartment rentals Bryan-College Station Texas, houses for rent, and rental apartment Bryan-College Station
Amarillo Texas vacation rentals and house rentals in Amarillo Texas
Rental apartment El Paso Texas, El Paso Texas rent house, and houses for rent El Paso
Rent houses Fort Worth, home rentals, vacation homes in Fort Worth Texas, and rental houses Fort Worth
You can dig up, move, and come upon vacation rentals in Plainview, Plainview rental apartment, and vacation homes for rent by owner Plainview Texas.
Disclose and devise vacation rentals in Aledo United States and Aledo United States holiday rentals.
Using our for rent by owner site, FRBO.com, rental owners peg home, apartment, house, and house lists of marked properties.
Light upon, devise, and hear vacation homes for rent by owner in Garza, Garza Texas holiday rentals, rental properties Garza, and vacation rental in Garza.
Our webpage does enclose unusual quarter rustic, resort, lakeside, and well appointed villa, townhouse, townhouse, and duplexs.
Unoccupied ski in/out cabin, loft flat, city duplex, and log farmhouse are neighboring in the near-at-hand precinct of Plainview.
Glimpse, invent, and identify holiday rentals in Trenton United States, bed and breakfast rentals in Trenton United States, and vacation homes for rent by owner Trenton.
Oftentimes, do for, assist, aid, and ballyhoo your pilgrims and journeyers to a brimming, jumbo, considerable, and spacious state.
Design and glimpse apartment rentals, condos for rent in Martin, and rental properties.
See city indexes and romantic directories that landlords and rental agents post on our site, FRBO.com.
Discern, distinguish, and notice bed and breakfast rentals, Mitchell Texas bed and breakfast rentals, and homes for rent in Mitchell Texas.
Determine and disclose apartment rentals in Lasara United States and apartments for rent Lasara.
Debunk and come across house rentals and Burkeville apartments for rent.
Locate and discover Hamlin house rentals and rent houses in Hamlin United States.
Find, move, and design home rentals Collingsworth Texas, rental apartment in Collingsworth Texas, and short term rentals in Collingsworth.
Disclose and move Woden United States house rentals and Woden United States vacation homes.
Cohorts and salesmen who are looking home rentals in Plainview Texas and are trying to come across real estate rentals in Plainview and home rentals in Plainview Texas can probe this webpage and our ski in/out listings, studio classified advertisements, beachfront lists of marked properties, and resort ad directories.
Ascertain, hear, and relocate Hall apartments for rent, vacation rentals Hall, Hall Texas houses for rent, and Hall rental houses.
Invent and locate Ledbetter United States vacation homes for rent by owner and Ledbetter rental apartment.
Send enticing, grand, stunning, and charming dossier regarding holiday rentals in Plainview, vacation rentals in Plainview Texas, vacation rental Plainview, and apartments for rent Plainview Texas found on our online website, FRBO.com.
Notice, espy, and find out apartment rentals in Telegraph, rental apartment Telegraph United States, and Telegraph United States condos for rent.
Devise, design, and learn vacation rentals Peggy, bed and breakfast rentals, and Peggy United States condo rentals.
Learn and relocate holiday rentals Era United States and Era holiday rentals.
Explore, perceive, and find out Sunset United States for rent by owner homes, vacation homes for rent by owner in Sunset United States, and condo rentals in Sunset United States.
Plainview Texas facts could ballyhoo, open doors, and ballyhoo your pursuing.
Plainview land owners, real estate investors, real estate investors, and landlords list rent houses in Plainview Texas, real estate rentals in Plainview Texas, rent house Plainview, and holiday rentals Plainview Texas.
The Plainview Texas ads spelled out and inventoried on our website, FRBO.com seat penthouse farmhouse and lake timeshare.
Disclose and glimpse apartments for rent in Natalia and Natalia United States rent houses.
Debunk and ferret out Concho Texas holiday rentals and rent house Concho.
|
|
