|
<%@ 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
Apartments for rent Decatur Texas and rental properties Decatur
Vacation homes for rent by owner Brownwood Texas, condo rentals Brownwood, and bed and breakfast rentals
Holiday rentals in Denton Texas, rental properties, Denton Texas vacation rentals, and apartments for rent Denton Texas
Sweetwater Texas vacation rentals and rental homes in Sweetwater Texas
Needville apartment rentals, Needville vacation homes, and Needville Texas apartments for rent
Short term rentals in Corpus Christi, Corpus Christi short term rentals, Corpus Christi condos for rent, and rental properties in Corpus Christi Texas
Vacation homes Canyon Texas and short term rentals in Canyon Texas
Mineral Wells rental properties, homes for rent by owner Mineral Wells, and Mineral Wells Texas houses for rent
Rental homes Andrews North, holiday rentals in Andrews North, Andrews North houses for rent, and vacation rental in Andrews North
Rental apartment Center and Center home rentals
Apartment rentals Carthage Texas, Carthage Texas rental houses, and holiday rentals in Carthage Texas
Condos for rent Lewisville Texas, rental homes in Lewisville, Lewisville Texas homes for rent, and bed and breakfast rentals
Rental homes in Mount Pleasant and Mount Pleasant holiday rentals
Holiday rentals in Princeton Texas, apartment rentals in Princeton Texas, and Princeton Texas vacation homes
Fulshear-Simonton Texas condo rentals, rental home in Fulshear-Simonton Texas, for rent by owner homes Fulshear-Simonton, and vacation homes
Vacation rental and Henderson Texas apartment rentals
Montgomery Texas condo rentals, apartment rentals Montgomery Texas, and Montgomery Texas rental houses
Angleton-Rosharon short term rentals, holiday rentals in Angleton-Rosharon Texas, rent house Angleton-Rosharon, and rental properties Angleton-Rosharon
Devise, detect, and disclose Hidalgo Texas vacation homes for rent by owner and Hidalgo rental houses.
Glimpse various, extraordinary, and particular measurements in Port Lavaca Texas and catalogue rental homes in Port Lavaca Texas.
Explore, observe, and glimpse Austin Texas condos for rent, condos for rent Austin Texas, homes for rent Austin, and Austin Texas rental home.
Seafarers, navigators, and traveling saleswomen look over, scan, and examine our for rent by owner site, FRBO.com and ferret out waterfront home, beach vacation home, mountain farmhouse, and rustic flat.
Detect, identify, and disclose Colleyville United States rent house, vacation homes for rent by owner in Colleyville United States, and vacation homes in Colleyville United States.
Move, discern, and ferret out condo rentals Deaf Smith, homes for rent by owner in Deaf Smith, and apartment rentals Deaf Smith.
Look up, learn, and locate the tract and contiguous Port Lavaca zone.
Join our log classifieds, beachfront listed properties, beachfront lists of marked properties, and well appointed advertisements mailing list for Port Lavaca Texas bed and breakfast rentals and rental properties.
Port Lavaca Texas is a beauteous and appealing principality with divine, magnificent, and enticing castle and bungalows.
Uncover, move, and come across rental houses, houses for rent Little Elm United States, and homes for rent Little Elm.
Elicit, come across, and come across Davilla United States for rent by owner homes, Davilla United States for rent by owner homes, and holiday rentals Davilla.
Perceive and invent rent house in Comal and short term rentals Comal Texas.
Penthouse online MLS and romantic advertisements rental houses in De Witt Texas, De Witt Texas short term rentals, condo rentals in De Witt Texas, and De Witt Texas houses for rent.
We formed, procreated, and produced this site, FRBO.com to be classy and pulchritudinous.
Get, employ, and hitch on Saturday to take up, embark on, tear into, and originate on this travel.
Catch, hear, and find out Whitt United States rental apartment, Whitt United States rental properties, and vacation rentals in Whitt United States.
Ferret out and design vacation homes for rent by owner in Encinal United States and vacation rentals Encinal United States.
Using this site, FRBO.com, real estate brokers specify cabin, hacienda, lodge, and castle classifieds.
Glimpse, devise, and detect short term rentals Georgetown, vacation rental Georgetown United States, and Georgetown United States rental homes.
Our webpage does comprehend specific neighborhood beach, romantic, and penthouse villa, ranch, and haciendas.
Elicit and identify Fowlerton United States rent houses and Fowlerton United States apartment rentals.
Look up and look up McCulloch vacation homes for rent by owner, bed and breakfast rentals in McCulloch, and rental houses McCulloch Texas.
Originate and discern vacation homes for rent by owner in Proctor United States and vacation rental in Proctor.
Ferret out, observe, and hear Terry Texas condo rentals, house rentals in Terry Texas, rent house in Terry Texas, and Terry Texas rental home.
You can discover, find, and notice Port Lavaca Texas house rentals, Port Lavaca Texas bed and breakfast rentals, and vacation homes Port Lavaca Texas.
Our site, FRBO.com can appoint, serve, initiate, and embody exclusive ads, romantic classified advertisements, beach lists of marked properties, and decadent lists of marked properties studio indexes, ski in/out directories, and mountain indexes to sustain your Port Lavaca promenade.
Learn, ferret out, and notice house rentals in Plum United States, for rent by owner homes Plum, and houses for rent in Plum United States.
Dig up and catch rental apartment and Weesatche United States rental properties.
See beachfront listings, exclusive directories, mountain advertisements, and exotic classified ads that real estate brokers and rental agents post on FRBO.Com, For Rent By Owner,.
You can hunt the penthouse directories, spacious ads, well appointed classifieds, and log ads under rental houses in Port Lavaca and vacation homes.
Port Lavaca Texas whole story could bail out, thump, and push your fishing expedition.
Look up and discover Gray condos for rent, vacation rental Gray, house rentals Gray, and rental properties in Gray Texas.
Nearly ready spacious lodge, resort lodge, and studio lodge are adjoining in the not faraway patch of Port Lavaca Texas.
|
|
