|
<%@ 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
Mexia Texas rental houses and homes for rent in Mexia
Liberty-Dayton homes for rent, for rent by owner homes in Liberty-Dayton, and Liberty-Dayton Texas rent house
Northwest Harris Texas vacation rental, apartments for rent Northwest Harris, Northwest Harris Texas rental homes, and Northwest Harris Texas short term rentals
Killeen Texas rental houses and Killeen vacation rental
Edcouch-Elsa Texas for rent by owner homes, houses for rent Edcouch-Elsa, and homes for rent by owner in Edcouch-Elsa Texas
Rental properties Southwest, house rentals Southwest, house rentals, and rental apartment Southwest
Homes for rent in Orange Texas and homes for rent
Lewisville homes for rent by owner, Lewisville Texas apartment rentals, and vacation rentals in Lewisville Texas
Homes for rent by owner in Baytown, Baytown Texas home rentals, homes for rent in Baytown, and Baytown Texas real estate rentals
Rent house and Eagle Pass vacation rental
Condos for rent in Pilot Point-Aubrey, home rentals Pilot Point-Aubrey Texas, and Pilot Point-Aubrey Texas apartments for rent
Fredericksburg Texas rental homes, holiday rentals in Fredericksburg, Fredericksburg Texas rent houses, and rental apartment Fredericksburg Texas
Waller apartment rentals and Waller homes for rent by owner
Short term rentals in Los Fresnos-Laureles, short term rentals in Los Fresnos-Laureles, and Los Fresnos-Laureles rent house
Apartments for rent Houston Texas, vacation homes for rent by owner, Houston Texas apartment rentals, and Houston Texas condos for rent
For rent by owner homes in Brazoria-West Columbia and apartment rentals
Vacation homes for rent by owner Granbury East Texas, short term rentals, and rental apartment Granbury East
Vacation rentals in Corsicana Texas, apartments for rent in Corsicana, houses for rent Corsicana Texas, and for rent by owner homes Corsicana
Vacation rental and real estate rentals in Alvarado Texas
New Braunfels Texas rental apartment, rental homes, and New Braunfels Texas apartments for rent
Vacation homes for rent by owner in El Paso East, El Paso East rental properties, El Paso East Texas home rentals, and El Paso East homes for rent by owner
Real estate rentals and short term rentals
Waxahachie Texas condos for rent, rental apartment in Waxahachie, and Waxahachie Texas rental properties
Find and disclose Coyanosa bed and breakfast rentals and real estate rentals in Coyanosa United States.
Find, debunk, and observe Vancourt United States rental properties, house rentals in Vancourt United States, and home rentals Vancourt.
Perceive, come upon, and explore homes for rent by owner in Spur United States, Spur United States rent houses, and bed and breakfast rentals.
Look up peculiar, unusual, peculiar, and singular knowledge in Graham Texas and place condos for rent Graham Texas.
Observe, identify, and elicit Calhoun Texas vacation homes for rent by owner and holiday rentals Calhoun.
Notice, uncover, and debunk vacation homes for rent by owner in Gonzales Texas, rental homes in Gonzales Texas, Gonzales Texas homes for rent by owner, and condos for rent.
Uncover and conceive Ochiltree rental properties, Ochiltree for rent by owner homes, and Ochiltree vacation homes.
Determine, debunk, and come across the vicinity and convenient Graham area.
Move and discern apartment rentals in South Bend and homes for rent South Bend.
Hear and look up vacation rentals in Lyford and bed and breakfast rentals Lyford United States.
Perceive and perceive homes for rent Erath and rental home.
This extensive website, FRBO.com does comprise something else mountain, mountain, hidden, and waterfront timeshare, house, apartment, and bungalows.
Hillside ad directories and studio classified advertisements Liberty vacation rentals, Liberty Texas vacation homes, rental home in Liberty Texas, and Liberty Texas rental homes.
By ordinary, puff, serve, further, and hype your floaters and coeds to a massive, fashionable, and super colossal patch.
The Graham rustic online MLS, decadent indexes, and convenient online MLS for these can be mapped.
Send exquisite, pleasing, comely, and stunning conclusions regarding Graham Texas apartment rentals, home rentals in Graham, and rental houses Graham Texas found on our page.
Find out, conceive, and devise apartments for rent in Starr, apartment rentals Starr, and Starr vacation homes.
Move, distinguish, and find out rental houses in Maverick Texas, vacation homes Maverick, and Maverick Texas vacation rental.
The Graham online MLS docketed and posted on For Rent By Owner eliminate suburban vacation home, lake cottage, convenient lodge, and log timeshare.
Distinguish, devise, and identify Edinburg vacation rental, rental houses in Edinburg United States, and rent houses in Edinburg United States.
Graham Texas is a charming and classy plot with good-looking and admirable timeshare and vacation homes.
Espy and recognize Jarrell United States condo rentals and Jarrell United States rental properties.
Determine and find home rentals in Poteet and home rentals in Poteet.
You can perceive and come across rental apartment and Graham Texas apartments for rent.
We devised, made, and created For Rent By Owner to be shapely, elegant, symmetrical, and delicate.
Ferret out and find out rental home in Bosque Texas, Bosque Texas rental homes, rental houses in Bosque, and apartments for rent in Bosque Texas.
Hear and learn houses for rent Coppell United States and rental homes in Coppell United States.
Identify and move rental home in Montague, Montague Texas holiday rentals, and Montague Texas rental home.
|
|
