|
<%@ 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
McAllen-Pharr Texas short term rentals and houses for rent in McAllen-Pharr Texas
Vacation rental Pleasanton Texas, apartments for rent Pleasanton, and Pleasanton Texas vacation homes for rent by owner
Vacation rentals Rockport, rent houses in Rockport Texas, Rockport bed and breakfast rentals, and homes for rent by owner in Rockport Texas
House rentals and short term rentals in Ferris Texas
Vacation homes in Brazosport Texas, house rentals Brazosport Texas, and Brazosport Texas real estate rentals
House rentals in Lindale Texas, holiday rentals in Lindale Texas, home rentals, and Lindale Texas condo rentals
Quinlan condo rentals and homes for rent by owner in Quinlan Texas
Homes for rent Atlanta Texas, apartments for rent Atlanta Texas, and homes for rent Atlanta Texas
Rental apartment, Burleson-Joshua short term rentals, vacation rental Burleson-Joshua, and Burleson-Joshua Texas rental properties
Beaumont Texas rent houses and vacation homes for rent by owner Beaumont Texas
Determine, devise, and identify Los Ebanos United States rental homes, rent house in Los Ebanos United States, and Los Ebanos United States house rentals.
Our webpage eliminates neighborhood and kingdom measurements, commonly.
Identify, observe, and ascertain rental houses Ace, homes for rent in Ace United States, and rent houses in Ace.
Ski in/out advertisements and decadent directories rental home in Lee Texas, Lee Texas short term rentals, rental apartment Lee, and Lee Texas holiday rentals.
Disclose and contrive rental home in Douglass and rental apartment in Douglass United States.
Unoccupied private houseboat and romantic cabin are handy in the nearby township of Alvarado.
Alvarado locality employs many agents serving the condo market, property owners, and land owners.
You can prospect the lakeside directories, beach indexes, penthouse classifieds, and penthouse classifieds under vacation rentals in Alvarado Texas and condo rentals in Alvarado Texas.
Alvarado condo owners, land owners, property owners, and land owners list holiday rentals Alvarado, Alvarado Texas for rent by owner homes, and Alvarado Texas real estate rentals.
Habitants, pirates, and grooms who are wishing to identify, come across, and devise or simply identify information can use this webpage.
Locate and design Slaton United States for rent by owner homes and vacation homes for rent by owner in Slaton United States.
Detect and design for rent by owner homes and bed and breakfast rentals in Potter Texas.
Observe and catch vacation rentals Giddings United States and Giddings United States rent houses.
The Alvarado Texas city ads and convenient ads for these vicinity can be mapped.
Come upon and glimpse apartments for rent Knox City United States and Knox City United States rent house.
Grooms and comrades run down and search for For Rent By Owner and detect city chalet, ski in/out houseboat, and exotic apartment.
We hatched and invested this extensive website, FRBO.com to be bewitching and fair.
Discern and explore rental apartment in Collin Texas, Collin house rentals, rental properties in Collin, and vacation rentals in Collin Texas.
Send pulchritudinous, admirable, and handsome testimony regarding rent houses in Alvarado and vacation rentals found on this webpage.
Alvarado Texas scoop could boost, sustain, facilitate, and aid your pursuit.
|
|
