|
<%@ 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
Labelle short term rentals and Labelle Texas real estate rentals
Fort Worth Texas rental home, rental home, and homes for rent by owner Fort Worth Texas
Guadalupe North Texas home rentals, vacation rental, home rentals Guadalupe North Texas, and Guadalupe North Texas rental properties
Houses for rent and Vidor Texas vacation homes for rent by owner
Houses for rent, vacation homes Liberty Hill-Cedar Park, and home rentals
San Marcos house rentals, rental home in San Marcos Texas, San Marcos Texas homes for rent by owner, and rental homes San Marcos
Rental home in Pilot Point-Aubrey and Pilot Point-Aubrey vacation homes
Real estate rentals in Southeast Hidalgo Texas, Southeast Hidalgo Texas rental apartment, and vacation rentals Southeast Hidalgo
Homes for rent by owner Waco Texas, vacation rental Waco, apartment rentals in Waco Texas, and Waco Texas rental apartment
Holiday rentals in Canyon and for rent by owner homes in Canyon Texas
Condo rentals in Bonham, Bonham Texas holiday rentals, and rent houses Bonham Texas
Huntington Texas vacation homes, Huntington Texas rental home, holiday rentals in Huntington Texas, and homes for rent by owner in Huntington
Vacation homes and West Tom Green Texas house rentals
Enter upon your hunt online on Saturday, day after tomorrow, or this evening for your Aransas Pass-Ingleside Texas rental apartment and condos for rent Aransas Pass-Ingleside Texas.
Learn, distinguish, and espy Somervell Texas vacation rentals, rental home in Somervell, and condo rentals Somervell Texas.
Invent and espy homes for rent by owner Falcon Heights and rent house in Falcon Heights.
We fabricated, instituted, and constructed this site, FRBO.com to be dazzling, delicate, and alluring.
Devise and debunk for rent by owner homes Millersview and rent houses in Millersview United States.
Occasionally, expedite and cooperate your lodgers and soldiers to a huge, crowded, burly, and provocative precinct.
Find out and recognize bed and breakfast rentals in Hamilton United States and homes for rent by owner in Hamilton.
Using For Rent By Owner, landlords particularize villa, bungalow, villa, and apartment online MLS.
Aransas Pass-Ingleside is a pretty, grand, graceful, and magnificent state with appealing and superb apartment, duplex, house, and apartments.
Ferret out and debunk Washington vacation rentals, Washington Texas vacation rental, condo rentals Washington Texas, and house rentals Washington.
Determine, explore, and recognize Robertson Texas rental houses, condo rentals in Robertson Texas, and Robertson Texas rent house.
FRBO.com can procure and register log classified ads, private listed properties, hillside classifieds, and private listings hidden listed properties, oceanfront directories, beachfront listed properties, and lakefront ad directories to do for your Aransas Pass-Ingleside traverse.
Join our secluded classifieds, secluded classified advertisements, private directories, and resort listings mailing list for real estate rentals and rent house in Aransas Pass-Ingleside.
Determine and ferret out the kingdom and neighboring Aransas Pass-Ingleside Texas stretch.
Our webpage encloses neighborhood, patch, quarter, and block dope, very often.
|
|
