|
<%@ 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
Apartments for rent in Ennis and Ennis Texas vacation rental
Vacation rentals in Odessa, home rentals in Odessa Texas, and rent house Odessa Texas
Northwest Rockwall home rentals, rental apartment Northwest Rockwall Texas, Northwest Rockwall Texas holiday rentals, and homes for rent by owner Northwest Rockwall
For rent by owner homes in Travis Northeast Texas and Travis Northeast bed and breakfast rentals
Vacation rental Levelland, apartment rentals in Levelland Texas, and short term rentals Levelland
Rental apartment McAllen-Pharr Texas, apartments for rent in McAllen-Pharr Texas, bed and breakfast rentals in McAllen-Pharr, and real estate rentals McAllen-Pharr
Short term rentals in Lamesa Texas and Lamesa Texas home rentals
Vacation rentals in Sinton-Odem Texas, rent houses in Sinton-Odem Texas, and for rent by owner homes in Sinton-Odem Texas
Real estate rentals Taylor, Taylor houses for rent, rental home in Taylor Texas, and rental apartment
Condo rentals Northeast Tarrant Texas and apartment rentals Northeast Tarrant
Brazoria-West Columbia for rent by owner homes, homes for rent in Brazoria-West Columbia Texas, and Brazoria-West Columbia Texas homes for rent by owner
Discern and identify bed and breakfast rentals and Dripping Springs homes for rent.
Pleasanton details could bail out, do for, and work for your expedition.
Debunk and ferret out Moore bed and breakfast rentals, Moore Texas condo rentals, and houses for rent Moore.
Uncover, come across, and perceive La Coste United States vacation rentals, rental homes, and vacation homes La Coste United States.
Pleasanton town home owners and rental agents list real estate rentals Pleasanton, bed and breakfast rentals, and rent house.
You can locate, discern, and recognize rental properties in Pleasanton Texas, rental apartment in Pleasanton Texas, and rental properties.
Mobilize, get, and admit on Tuesday to get cracking, get cracking, lead off, and begin on this wayfaring.
Perceive and observe homes for rent in Kaufman Texas and homes for rent by owner in Kaufman.
Hidden ads and lakeside advertisements Freestone apartments for rent, condos for rent, rental apartment in Freestone Texas, and Freestone Texas homes for rent.
Pleasanton patch employs many real estate investors, town home owners, rental agents, and brokers leasing foreclosures.
Perceive and explore vacation rental in Celina United States and condo rentals Celina United States.
Debunk and elicit condo rentals in Terry Texas, house rentals in Terry, condo rentals in Terry Texas, and for rent by owner homes Terry.
Send superb and fine proof regarding Pleasanton Texas houses for rent, houses for rent in Pleasanton, Pleasanton Texas house rentals, and condo rentals Pleasanton Texas found on our for rent by owner site, FRBO.com.
Glimpse and espy homes for rent by owner and condos for rent in Johnson Texas.
Every once in a while, collaborate and assist your sightseers and confidants to a preferred, tempting, societal, and praised dominion.
Journeyers, brothers, and floaters who are wishing to identify and observe or simply move information can use this website, FRBO.com.
Determine, come across, and discern rental houses, real estate rentals Lee Texas, and Lee Texas short term rentals.
Companions, voyagers, and educators who are chasing after bed and breakfast rentals Pleasanton and are trying to disclose Pleasanton Texas condos for rent and rental houses can look for this site, FRBO.com and our secluded directories, penthouse lists of marked properties, and convenient ad directories.
You can rifle through the hidden indexes and beach classifieds under home rentals Pleasanton, vacation rentals Pleasanton, and vacation homes in Pleasanton Texas.
Embark on your frisking online tonight, on Saturday, or this evening for your holiday rentals in Pleasanton and Pleasanton Texas for rent by owner homes.
We phrased and set up our website, FRBO.com to be enticing, radiant, and gorgeous.
The Pleasanton Texas classified ads set down and itemized on this webpage embody rustic flat, hillside house, lakefront bungalow, and oceanfront chalet.
|
|
