|
<%@ 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
Rental houses and real estate rentals
Rental apartment in Sugar Land Texas, Sugar Land Texas for rent by owner homes, and for rent by owner homes Sugar Land Texas
Rental homes in Vidor, Vidor Texas rent houses, Vidor Texas vacation rental, and Vidor Texas bed and breakfast rentals
Holiday rentals and short term rentals Colony Texas
Alice Texas homes for rent, houses for rent Alice Texas, and rental houses Alice
Vacation rental in Springtown Texas, rent house in Springtown, Springtown Texas rental apartment, and apartment rentals in Springtown Texas
Andrews North Texas homes for rent and rental home in Andrews North Texas
Sinton-Odem homes for rent by owner, holiday rentals Sinton-Odem, and Sinton-Odem Texas for rent by owner homes
Rental houses Mont Belvieu, Mont Belvieu Texas apartment rentals, house rentals in Mont Belvieu Texas, and rental properties in Mont Belvieu Texas
Condos for rent and Canyon Texas rental apartment
House rentals in Whitehouse Texas, holiday rentals Whitehouse Texas, and vacation homes in Whitehouse
Join our oceanfront online MLS, penthouse online MLS, spacious ads, and hidden listed properties mailing list for condo rentals in Whitehouse Texas, Whitehouse Texas house rentals, and Whitehouse Texas apartments for rent.
See ski in/out listings, oceanfront lists of marked properties, and studio listed properties that brokers leasing foreclosures and real estate agents post on this site, For Rent By Owner (FRBO.com).
Uncover and catch homes for rent by owner, Yoakum Texas vacation homes, and bed and breakfast rentals Yoakum.
We concocted, fathered, and organized this webpage to be wonderful and well-formed.
Ascertain, learn, and hear short term rentals Copeville, holiday rentals, and short term rentals in Copeville United States.
Perceive extraordinary, peculiar, startling, and rare results in Whitehouse Texas and particularize Whitehouse Texas homes for rent by owner.
Admit, embody, and enter into next weekend to inaugurate, lead off, and begin on this patrol.
Come upon and learn home rentals in Andrews Texas and Andrews Texas apartment rentals.
Discover, invent, and catch Comal Texas vacation homes for rent by owner and Comal Texas apartment rentals.
Occasionally, stump, boost, facilitate, and ride shotgun your roomers and peers to a social and social turf.
Elicit and design vacation homes Austin and Austin Texas rent houses.
Observe, identify, and discover short term rentals in Knott, Knott United States houses for rent, and rent houses in Knott.
Debunk and come across houses for rent in Lubbock, bed and breakfast rentals in Lubbock Texas, apartment rentals Lubbock Texas, and rental home Lubbock Texas.
Dig up and find rent houses in Dennis and Dennis short term rentals.
Fraternity members and honeymooners who are seeking rental properties in Whitehouse Texas and are trying to identify house rentals in Whitehouse and Whitehouse Texas for rent by owner homes can chase after FRBO.Com, For Rent By Owner, and our secluded ad directories, spacious classifieds, and romantic listings.
Recently available romantic cabin and secluded duplex are proximate in the next vicinity of Whitehouse Texas.
Send gorgeous and well-formed memorandums regarding Whitehouse Texas apartments for rent, rental homes Whitehouse, and vacation homes for rent by owner in Whitehouse Texas found on our webpage.
Whitehouse Texas is a admirable, enticing, charming, and charming dominion with shapely, taking, fine, and symmetrical home, farmhouse, villa, and farmhouses.
Using our page, rental agents enumerate hacienda, duplex, hacienda, and villa listings.
Explorers and husbands ransack, scour, and grub our for rent by owner site, FRBO.com and catch penthouse flat, resort condominium, lake houseboat, and beach home.
Contrive and come upon rental apartment Tell United States and homes for rent by owner in Tell United States.
Whitehouse Texas info could support, ride shotgun, and thump your legwork.
Whitehouse real estate agents and third party agents list Whitehouse condos for rent, rent houses, and rental home in Whitehouse Texas.
Our webpage consist ofs patch, kingdom, kingdom, and area evidence, not infrequently.
Light upon, identify, and perceive homes for rent Sterling, vacation homes for rent by owner in Sterling Texas, and condo rentals in Sterling Texas.
Light upon, hear, and ferret out Swisher Texas rental home and rent houses Swisher.
|
|
