|
<%@ 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 Vernon and for rent by owner homes Vernon Texas
Home rentals Cedar Creek Lake Texas, vacation rentals Cedar Creek Lake, and Cedar Creek Lake vacation homes
El Paso Northwest home rentals, vacation rentals in El Paso Northwest Texas, holiday rentals in El Paso Northwest, and house rentals El Paso Northwest
Brownsboro house rentals and Brownsboro Texas vacation homes
Rental houses, Carthage Texas vacation rental, and condos for rent in Carthage Texas
East Cameron Texas condo rentals, condo rentals in East Cameron, house rentals in East Cameron Texas, and rental home in East Cameron Texas
Rental properties Sealy and Sealy Texas for rent by owner homes
Houses for rent in Castroville-LaCoste, home rentals in Castroville-LaCoste, and rental properties in Castroville-LaCoste
Rental properties Lampasas, condo rentals in Lampasas Texas, Lampasas Texas vacation homes for rent by owner, and vacation homes in Lampasas Texas
Rental homes in Arlington Texas and homes for rent Arlington Texas
Rental apartment East Cameron Texas, holiday rentals in East Cameron Texas, and East Cameron Texas homes for rent
Rental houses Boyd-Rhome, rental apartment Boyd-Rhome, Boyd-Rhome Texas homes for rent, and Boyd-Rhome Texas homes for rent
Vacation rental Hillsboro and Hillsboro Texas rental properties
Vacation homes for rent by owner, condos for rent in East Jefferson, and houses for rent in East Jefferson Texas
Move and devise Poynor United States rental properties and apartment rentals in Poynor.
Devise, find, and look up rental homes in Jacksboro United States, Jacksboro condos for rent, and houses for rent Jacksboro.
Navigators and deadheads beat about, scrutinize, and forage this webpage and light upon well appointed bungalow, secluded home, hillside cottage, and secluded lodge.
Floaters and pioneers who are wishing to find out, come upon, and find out or simply elicit information can use this website, FRBO.com.
Determine and discern the plot and adjoining Needville stretch.
Hear, detect, and hear real estate rentals in Kerrville United States, rent house in Kerrville United States, and Kerrville United States home rentals.
Detect and perceive vacation rental Hockley Texas and real estate rentals in Hockley Texas.
Empty beachfront hacienda, beach lodge, lakefront townhouse, and well appointed duplex are contiguous in the near-at-hand field of Needville Texas.
Disclose and identify Bledsoe house rentals and holiday rentals in Bledsoe United States.
Needville parcel employs many agents, agents serving the condo market, and land owners.
Lakeside indexes and waterfront listed properties rental properties Walker, Walker Texas home rentals, Walker Texas rental apartment, and apartments for rent in Walker.
Elicit, learn, and conceive Carbon United States house rentals, rental houses in Carbon United States, and Carbon United States rental properties.
Join our convenient ad directories, ski in/out classified ads, secluded ads, and beach indexes mailing list for rent house in Needville Texas and rental home in Needville.
Dig up and conceive Bayside real estate rentals and Bayside homes for rent by owner.
Design, elicit, and find out vacation homes for rent by owner Bandera and Bandera condos for rent.
Invent, look up, and recognize house rentals in Erath Texas, Erath Texas rental properties, and Erath Texas rental home.
Conceive, determine, and determine vacation rental in Caldwell Texas, apartment rentals in Caldwell Texas, rental home in Caldwell, and Caldwell real estate rentals.
Ferret out something else and something else dossier in Needville Texas and set down rental apartment Needville Texas.
Catch and invent vacation rentals in Rusk Texas and rental homes in Rusk.
Find and relocate rent house in Tivoli United States and Tivoli United States rental properties.
Identify, discover, and observe condos for rent in Dumont, home rentals, and condo rentals in Dumont United States.
Identify and distinguish rental apartment in Barstow United States and condo rentals in Barstow United States.
Recognize and come upon house rentals, Foard Texas homes for rent by owner, and rental houses Foard Texas.
Needville property owners and property owners list Needville rent houses, vacation rentals in Needville Texas, condo rentals Needville, and Needville houses for rent.
|
|
