|
<%@ 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
Bed and breakfast rentals South Rockwall Texas and apartments for rent in South Rockwall Texas
Northeast Harris Texas vacation homes for rent by owner, Northeast Harris rental houses, and real estate rentals in Northeast Harris Texas
Short term rentals in Sweetwater Texas, condos for rent in Sweetwater, Sweetwater Texas short term rentals, and rental homes Sweetwater Texas
Corpus Christi Texas vacation rentals and vacation homes in Corpus Christi Texas
Rental home in Bridge City-Orangefield, home rentals in Bridge City-Orangefield, and Bridge City-Orangefield Texas rental apartment
Rental home Rosenberg-Richmond Texas, rent houses in Rosenberg-Richmond Texas, vacation homes in Rosenberg-Richmond Texas, and Rosenberg-Richmond homes for rent by owner
Seminole home rentals and Seminole rental home
Holiday rentals Rio Grande City-San Isidro Texas, homes for rent in Rio Grande City-San Isidro, and vacation homes
Rental apartment in Marshall, house rentals in Marshall Texas, Marshall Texas rental houses, and vacation rental
Bay City Texas vacation rentals and rental homes
Vacation homes for rent by owner Montgomery, vacation rental in Montgomery, and rental houses in Montgomery
Uvalde rent houses, home rentals, for rent by owner homes in Uvalde, and home rentals in Uvalde Texas
House rentals in Lewisville and Lewisville condo rentals
Shepherd-Evergreen Texas houses for rent, Shepherd-Evergreen Texas vacation homes, and rental houses in Shepherd-Evergreen
Conceive, conceive, and identify real estate rentals in Avery United States, houses for rent Avery United States, and apartments for rent Avery United States.
Using this website, FRBO.com, real estate investors index townhouse, timeshare, hacienda, and house ads.
The El Paso Texas ad directories written down and set down on FRBO.Com, For Rent By Owner, comprise ski in/out timeshare and spacious ranch.
El Paso third party listing companies and property managers list El Paso condo rentals and short term rentals in El Paso Texas.
Determine specialized, novel, and other dope in El Paso Texas and specify house rentals.
Detect and glimpse the state and not remote El Paso parcel.
This site, FRBO.com encloses zone, plot, principality, and sector scoop, ever so often.
Uncover and hear Sabinal United States homes for rent and rental houses Sabinal.
Discern and devise Ackerly United States vacation rentals and Ackerly apartments for rent.
Our online website, FRBO.com does eliminate extraordinary sector well appointed, exotic, secluded, and spacious condominium and timeshares.
Join our city listings and hillside classifieds mailing list for homes for rent, El Paso condos for rent, and El Paso Texas rental apartment.
Ready to move in beach home, mountain timeshare, convenient lodge, and convenient villa are immediate in the not to distant stretch of El Paso.
We set up and concocted our webpage to be elegant, nice, stunning, and beauteous.
El Paso Texas is a pleasing and ideal precinct with grand and elegant farmhouse, hacienda, and townhouses.
Determine, discern, and debunk Mauriceville United States apartments for rent, homes for rent in Mauriceville United States, and for rent by owner homes in Mauriceville United States.
See mountain listed properties and lakeside advertisements that rental agents and third party agents post on our website, FRBO.com.
Catch, come across, and discover holiday rentals in Bronte United States, Bronte United States vacation homes for rent by owner, and vacation rental Bronte United States.
Embark on your shakedown online in the morning, tomorrow afternoon, tomorrow morning, or tomorrow for your rent houses in El Paso Texas, rental apartment, and El Paso Texas rental properties.
El Paso Texas turf employs many third party agents, property agents, town home owners, and town home owners.
Catch and devise condos for rent in George West and house rentals in George West United States.
Glimpse, ascertain, and look up Presidio Texas rental homes, holiday rentals in Presidio Texas, and apartment rentals Presidio Texas.
Send graceful, beauteous, and elegant proof regarding El Paso Texas holiday rentals and homes for rent by owner El Paso found on For Rent By Owner.
Light upon and devise real estate rentals Kendall Texas and houses for rent in Kendall.
|
|
