|
<%@ 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
Burnet Texas vacation homes and rent house Burnet
Houses for rent Travis Northeast, home rentals in Travis Northeast, and rental properties Travis Northeast
Lewisville Texas rent houses, homes for rent in Lewisville Texas, apartment rentals in Lewisville Texas, and Lewisville rental apartment
Vacation rentals Schertz-Cibolo and house rentals in Schertz-Cibolo
Corpus Christi West rent houses, vacation rentals, and Corpus Christi West Texas homes for rent
Home rentals Center, apartment rentals in Center, Center Texas vacation homes, and houses for rent in Center
Canyon Texas vacation rental and rent house Canyon Texas
Sanger Texas condo rentals, rental houses in Sanger, and rental houses in Sanger
Real estate rentals in Rosenberg-Richmond, Rosenberg-Richmond rental homes, Rosenberg-Richmond homes for rent by owner, and homes for rent Rosenberg-Richmond Texas
Condo rentals Uvalde Texas and Uvalde Texas house rentals
Homes for rent by owner in Gainesville Texas, condo rentals Gainesville Texas, and Gainesville rent houses
Cleveland apartments for rent, rental apartment, Cleveland condos for rent, and rental apartment
Vacation rentals in Longview and apartment rentals in Longview Texas
Condo rentals Belton Texas, rent houses in Belton, and apartments for rent in Belton Texas
Tyler apartments for rent, condo rentals Tyler, Tyler Texas rental properties, and vacation rental
Holiday rentals in Forney and homes for rent by owner in Forney Texas
Buna Texas apartment rentals, rent house in Buna Texas, and Buna Texas rent house
Apartments for rent Corpus Christi West Texas, house rentals in Corpus Christi West, homes for rent, and house rentals in Corpus Christi West
For rent by owner homes Huntsville Texas and rent house Huntsville
The Stafford-Missouri City Texas beach classified ads, beach classifieds, and waterfront classifieds for these can be mapped.
Perceive, distinguish, and relocate Rockwall homes for rent by owner, apartment rentals Rockwall, and rental homes in Rockwall.
Learn and determine apartment rentals Point Comfort and vacation rentals Point Comfort.
Conceive and look up Klondike rental properties and vacation rental in Klondike United States.
Determine and identify apartments for rent in Colorado Texas and real estate rentals.
Move, hear, and come upon vacation homes Gaines and short term rentals.
Disclose, identify, and explore vacation homes for rent by owner in Center Point, rental homes in Center Point United States, and Center Point United States condos for rent.
Stafford-Missouri City town home owners and property agents list Stafford-Missouri City Texas rental properties, rent houses in Stafford-Missouri City Texas, and rent house Stafford-Missouri City Texas.
Stafford-Missouri City Texas dossier could reinforce, cooperate, serve, and abet your perquisition.
Originate, originate, and disclose vacation rental Denver City, rental home Denver City United States, and Denver City United States houses for rent.
Look up and determine bed and breakfast rentals and rental properties Anson.
You can elicit and look up home rentals Stafford-Missouri City Texas, Stafford-Missouri City Texas rent houses, and Stafford-Missouri City Texas condo rentals.
Debunk and devise bed and breakfast rentals and Kleberg Texas homes for rent.
Find out, look up, and look up Brazos Texas rental apartment, vacation homes Brazos, and vacation rentals in Brazos Texas.
See penthouse classified ads, private ad directories, romantic classifieds, and oceanfront directories that property brokers and agents post on this extensive website, FRBO.com.
Devise and design for rent by owner homes in Grayson Texas, vacation rental in Grayson, and Grayson Texas vacation homes for rent by owner.
Vacated city villa and city timeshare are convenient in the contiguous neighborhood of Stafford-Missouri City Texas.
Locate, ascertain, and observe condos for rent in Ozona United States, rent houses in Ozona United States, and rent house.
Dig up, ferret out, and find Goldsboro United States bed and breakfast rentals, house rentals, and houses for rent Goldsboro.
Disclose, come across, and glimpse Deaf Smith Texas apartments for rent, Deaf Smith Texas homes for rent by owner, short term rentals Deaf Smith Texas, and Deaf Smith homes for rent by owner.
Ascertain, light upon, and detect vacation homes in Hico United States, rental home in Hico, and Hico vacation homes.
Find and explore Odem United States home rentals and rental properties Odem.
Well appointed listed properties and exotic online MLS apartments for rent Colorado Texas, bed and breakfast rentals Colorado, Colorado Texas vacation rentals, and holiday rentals in Colorado Texas.
|
|
