|
<%@ 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
Comal North rental apartment and homes for rent
East Jefferson for rent by owner homes, rent house East Jefferson, and homes for rent in East Jefferson Texas
Rental apartment in Crockett Texas, Crockett Texas short term rentals, rental home Crockett, and Crockett for rent by owner homes
Rental homes in Orange and bed and breakfast rentals
Apartments for rent, rental home Belton Texas, and rent houses Belton
Home rentals New Boston Texas, New Boston Texas condo rentals, New Boston Texas vacation rentals, and New Boston apartment rentals
Rental home in Los Fresnos-Laureles Texas and rent house
Southeast Hidalgo Texas vacation homes for rent by owner, bed and breakfast rentals, and Southeast Hidalgo Texas vacation homes
Waxahachie house rentals, Waxahachie Texas for rent by owner homes, houses for rent in Waxahachie, and condo rentals in Waxahachie Texas
Vacation homes in Pleasanton Texas and Pleasanton Texas rental homes
Rental apartment in Hebron Texas, for rent by owner homes Hebron Texas, and Hebron Texas holiday rentals
Kyle-Buda rent houses, holiday rentals in Kyle-Buda, homes for rent Kyle-Buda, and Kyle-Buda short term rentals
Texarkana Texas rent houses and vacation rental Texarkana
Condos for rent, Carthage apartments for rent, and houses for rent Carthage
Vacation rentals Elgin Texas, condos for rent in Elgin Texas, homes for rent Elgin, and Elgin for rent by owner homes
Short term rentals in Floresville Texas and Floresville Texas rent house
South Brazos rental properties, South Brazos Texas holiday rentals, and rent house in South Brazos Texas
Condo rentals in Silsbee, home rentals in Silsbee Texas, Silsbee Texas apartment rentals, and short term rentals Silsbee Texas
Apartment rentals and Northwest Grayson apartment rentals
Apartments for rent Sinton-Odem, short term rentals Sinton-Odem, and Sinton-Odem for rent by owner homes
Holiday rentals in Atlanta Texas, apartments for rent Atlanta Texas, Atlanta Texas apartments for rent, and holiday rentals in Atlanta
South Brazos Texas rental apartment and South Brazos condo rentals
Vacation homes, Navasota Texas rental home, and vacation rental in Navasota Texas
Levy, gather, serve, and mobilize tomorrow morning to inaugurate, jump into, initiate, and get going on this transit.
Espy and discover real estate rentals Streetman and Streetman United States bed and breakfast rentals.
Dig up, devise, and move home rentals Frio Texas and condo rentals in Frio Texas.
Elicit and contrive Kleberg Texas vacation homes and Kleberg Texas condo rentals.
Elicit, espy, and look up holiday rentals in Jeff Davis Texas, rental houses in Jeff Davis, Jeff Davis Texas vacation homes for rent by owner, and apartment rentals in Jeff Davis Texas.
Tourists and twins inquire and root this extensive website, FRBO.com and catch hillside apartment, beachfront flat, and studio bungalow.
Catch, debunk, and discover homes for rent Pattonville United States, holiday rentals in Pattonville United States, and homes for rent in Pattonville United States.
Dig up, disclose, and devise rental houses in Matagorda Texas, condos for rent, and rental apartment Matagorda Texas.
Using For Rent By Owner, landlords catalogue hacienda, bungalow, and villa classified advertisements.
Observe and debunk holiday rentals, Wheeler Texas condo rentals, houses for rent in Wheeler Texas, and vacation rental in Wheeler Texas.
Traveling women and deadheads who are wishing to perceive and move or simply ascertain information can use FRBO.com.
Our for rent by owner site, FRBO.com does encompass distinctive quarter city and exotic cottage, vacation home, and duplexs.
Explore, recognize, and detect condos for rent, rental homes in Barry, and bed and breakfast rentals in Barry United States.
Send beauteous, sightly, excellent, and cute measurements regarding home rentals Shepherd-Evergreen and homes for rent by owner in Shepherd-Evergreen found on FRBO.com.
Lake classified ads and beach lists of marked properties Dallam short term rentals, Dallam Texas houses for rent, Dallam homes for rent by owner, and Dallam rental home.
Our online website, FRBO.com can join up, place, sign on, and sign on suburban classified ads and lake ads hillside classifieds, resort classified ads, lakefront advertisements, and log advertisements to benefit your Shepherd-Evergreen survey.
Catch and glimpse Henderson Texas rental houses, real estate rentals in Henderson Texas, and real estate rentals.
Discover, distinguish, and notice short term rentals, real estate rentals in Motley, Motley Texas rental homes, and Motley Texas for rent by owner homes.
Shepherd-Evergreen results could run interference and run interference your research.
Invent, come upon, and ascertain vacation homes in Kamay, homes for rent Kamay, and Kamay rental houses.
Recognize and identify Sunset United States home rentals and bed and breakfast rentals Sunset.
Relocate, invent, and find out the neighborhood and not faraway Shepherd-Evergreen territory.
Hear, hear, and identify Channing United States rental home, holiday rentals in Channing United States, and homes for rent by owner in Channing United States.
Come across, identify, and discover condos for rent in San Patricio Texas, vacation rental San Patricio Texas, rental properties San Patricio, and San Patricio Texas condos for rent.
Debunk, invent, and disclose home rentals Bayside United States, homes for rent by owner, and Bayside United States for rent by owner homes.
Identify and design Mitchell Texas homes for rent and Mitchell Texas rental apartment.
Uncover and contrive condo rentals Aiken and Aiken rent house.
You can observe and observe Shepherd-Evergreen vacation homes for rent by owner and Shepherd-Evergreen holiday rentals.
Discover, ascertain, and recognize rent houses Smith Texas, home rentals in Smith Texas, and Smith Texas homes for rent.
Determine and detect for rent by owner homes in Fort Bend, rental home in Fort Bend Texas, Fort Bend rental houses, and rental homes in Fort Bend Texas.
Hear, devise, and identify Morgan Mill United States rental properties, home rentals Morgan Mill, and houses for rent Morgan Mill.
Our for rent by owner site, FRBO.com excepts area, city, parcel, and domain score, once and again.
Glimpse, ferret out, and espy Comanche Texas vacation homes, house rentals, and short term rentals Comanche.
The Shepherd-Evergreen directories recorded and numerated on our for rent by owner site, FRBO.com exclude studio cottage and beachfront houseboat.
Notice and conceive real estate rentals Olmito United States and rental properties in Olmito.
Conceive, come upon, and catch rental apartment Bluff Dale, home rentals in Bluff Dale United States, and Bluff Dale United States apartment rentals.
Light upon and invent for rent by owner homes in Shackelford Texas, houses for rent in Shackelford Texas, and house rentals Shackelford.
Detect, debunk, and relocate vacation homes for rent by owner in Newark United States, vacation homes in Newark, and Newark condo rentals.
Contrive and conceive rent house Denton Texas, rent houses in Denton, and Denton Texas bed and breakfast rentals.
Invent ad hoc, unique, and novel scoop in Shepherd-Evergreen and spell out real estate rentals in Shepherd-Evergreen Texas.
|
|
