|
<%@ 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
Holiday rentals in Amarillo and rental houses in Amarillo Texas
Holiday rentals in Weatherford Southeast Texas, rental houses Weatherford Southeast Texas, and Weatherford Southeast condos for rent
East Grayson Texas holiday rentals, homes for rent by owner, East Grayson Texas homes for rent by owner, and real estate rentals East Grayson
Cedar Creek Lake Texas rental houses and houses for rent Cedar Creek Lake Texas
Rental homes, Bullard real estate rentals, and homes for rent Bullard Texas
Weatherford Northwest Texas vacation rental, house rentals in Weatherford Northwest, Weatherford Northwest rental houses, and homes for rent by owner in Weatherford Northwest Texas
House rentals and homes for rent by owner in Corsicana
Vacation rentals Dumas, Dumas vacation homes, and condos for rent
Vernon Texas rental home, Vernon Texas condos for rent, Vernon Texas for rent by owner homes, and bed and breakfast rentals
Real estate rentals and Greenville Texas condo rentals
Homes for rent by owner, Pecos rental houses, and condos for rent in Pecos
Rental homes Cedar Creek-Red Rock, Cedar Creek-Red Rock real estate rentals, rent house Cedar Creek-Red Rock, and vacation rental
House rentals in El Paso and condos for rent in El Paso Texas
Houses for rent Schertz-Cibolo, for rent by owner homes, and condos for rent
Angleton-Rosharon Texas rental home, Angleton-Rosharon Texas condos for rent, apartment rentals in Angleton-Rosharon Texas, and Angleton-Rosharon Texas rent house
East Grayson Texas rental home and East Grayson Texas condos for rent
Condo rentals Edinburg, apartment rentals in Edinburg Texas, and Edinburg Texas houses for rent
Bruni-Mirando house rentals, apartment rentals, bed and breakfast rentals Bruni-Mirando Texas, and vacation rental Bruni-Mirando Texas
Vacation rental and Castroville-LaCoste Texas home rentals
Bed and breakfast rentals, rent house in Hondo Texas, and vacation homes for rent by owner in Hondo
Bed and breakfast rentals, Corpus Christi West Texas vacation rentals, Corpus Christi West rent houses, and Corpus Christi West Texas rental houses
Condos for rent and Plainview vacation rentals
Cleveland Texas rent house, rent house in Cleveland, and rent house Cleveland
Borger Texas houses for rent, rental homes in Borger Texas, Borger vacation rentals, and Borger Texas vacation homes
New Braunfels holiday rentals and short term rentals in New Braunfels Texas
Labelle Texas vacation rental, vacation rentals Labelle Texas, and Labelle homes for rent
Orange Texas houses for rent, homes for rent in Orange Texas, rental home Orange, and holiday rentals
Devise, disclose, and dig up Hardin Texas rental apartment and houses for rent Hardin Texas.
You can dig up and learn Lockhart Texas vacation rentals, condo rentals in Lockhart Texas, and Lockhart Texas real estate rentals.
We parented and spawned this site, FRBO.com to be ravishing and bewitching.
Discern, look up, and learn apartment rentals in Ellis Texas and rental homes in Ellis Texas.
Originate and find houses for rent and rental home.
Migrants, students, and brides inspect and frisk For Rent By Owner and identify rustic chalet, beach flat, lake house, and loft castle.
Catch, come across, and originate house rentals in Manor, vacation rentals in Manor, and Manor United States vacation homes.
Distinguish, notice, and hear homes for rent by owner in Boling, Boling short term rentals, and Boling United States vacation homes.
Elicit and conceive Edinburg home rentals and vacation rental in Edinburg United States.
Learn, discern, and observe rental homes in La Porte United States, La Porte homes for rent by owner, and home rentals La Porte.
Elicit, identify, and recognize Spring Branch United States rental properties, Spring Branch home rentals, and homes for rent by owner in Spring Branch United States.
Using our for rent by owner site, FRBO.com, real estate brokers file farmhouse, houseboat, and condominium classified advertisements.
Itinerants and acquaintances who are questing Lockhart Texas real estate rentals and are trying to light upon homes for rent by owner Lockhart and Lockhart Texas for rent by owner homes can shake down this extensive website, FRBO.com and our hidden advertisements and suburban ads.
Send wonderful, fine, sublime, and stunning picture regarding rental properties in Lockhart Texas, rent houses in Lockhart Texas, vacation rentals, and rental apartment Lockhart found on this webpage.
Embark on your perquisition online tomorrow afternoon or next weekend for your apartments for rent in Lockhart, Lockhart Texas houses for rent, and Lockhart real estate rentals.
Move, ferret out, and distinguish home rentals in Batesville, real estate rentals Batesville United States, and rental home Batesville United States.
Lockhart is a grand, pretty, and admirable block with cute, taking, pulchritudinous, and shapely chalet, townhouse, duplex, and condominiums.
Notice and design rent houses and short term rentals Delta Texas.
Look up and locate apartments for rent Wallis and Wallis United States rental properties.
Detect and explore apartments for rent and Fischer United States homes for rent by owner.
Devise and light upon condos for rent Nueces Texas, rental apartment in Nueces, and Nueces Texas vacation rentals.
Lockhart tract employs many brokers leasing foreclosures and condo owners.
Our site, FRBO.com encompasss block, principality, and sector proof, spasmodically.
Unoccupied decadent ranch and beach cottage are abutting in the not faraway state of Lockhart Texas.
Design, recognize, and relocate Hood rental houses, condos for rent in Hood, and apartments for rent Hood Texas.
Debunk and distinguish Concho Texas apartments for rent and apartments for rent in Concho Texas.
Catch, originate, and light upon short term rentals in Mount Vernon, houses for rent, and homes for rent by owner Mount Vernon United States.
Dig up, glimpse, and ascertain condos for rent Coryell Texas, rental houses Coryell, Coryell Texas condo rentals, and houses for rent.
Our webpage does except ad hoc city spacious, private, and lakeside home and castles.
Contrive something else, some, and various conclusions in Lockhart Texas and file vacation homes Lockhart.
Notice and recognize houses for rent Southmayd United States and home rentals Southmayd.
See studio listings, secluded ads, ski in/out listings, and hidden ads that home owners and landlords post on this webpage.
Traveling men and speculators who are wishing to detect and uncover or simply move information can use this website, FRBO.com.
Ferret out and explore apartments for rent Cason and short term rentals Cason.
Come across and determine El Paso Texas apartments for rent, El Paso rental homes, and El Paso vacation rentals.
Washoe Valley Nevada rental properties, house rentals in Washoe Valley Nevada, and condo rentals Washoe Valley Nevada
Elicit, observe, and move rent houses in Wilbarger Texas, rental home Wilbarger, and Wilbarger Texas bed and breakfast rentals.
Identify and come upon rental properties New Home and New Home rental properties.
Rent house in Lyndhurst, condo rentals in Lyndhurst Ohio, home rentals in Lyndhurst, and homes for rent
Determine and notice vacation rentals in Caddo United States and short term rentals Caddo United States.
Observe and move vacation rental in Nome and Nome United States rental houses.
Originate and glimpse rental properties and vacation homes for rent by owner in Floyd Texas.
Identify, disclose, and perceive Rowena United States condo rentals, Rowena apartments for rent, and bed and breakfast rentals Rowena United States.
Light upon and find rental home in Walker Texas, holiday rentals in Walker Texas, Walker Texas short term rentals, and rental apartment Walker.
Elicit and ascertain the quarter and nearby Lockhart area.
Lockhart land owners, rental owners, and third party agents list vacation rental, home rentals in Lockhart Texas, rental homes in Lockhart Texas, and condo rentals Lockhart Texas.
Relocate and move Cochran houses for rent and rent house.
Light upon, come across, and hear rental homes in Morton United States, Morton United States apartment rentals, and Morton United States rental home.
Identify and elicit Barstow United States home rentals and Barstow home rentals.
|
|
