|
<%@ 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
Homes for rent by owner Sealy Texas and Sealy Texas house rentals
Vacation rental Levelland Texas, apartments for rent in Levelland, and Levelland Texas apartments for rent
Rent houses New Boston Texas, New Boston Texas apartment rentals, New Boston Texas vacation rentals, and rental apartment in New Boston Texas
Rental homes and home rentals in Livingston-New Willard Texas
Rent house in Robstown, houses for rent in Robstown Texas, and houses for rent Robstown Texas
Pittsburg Texas rent house, Pittsburg Texas house rentals, Pittsburg Texas rent house, and rental houses Pittsburg
Rental properties Pleasanton Texas and Pleasanton rent house
Vacation rentals, for rent by owner homes in Liberty Hill-Cedar Park Texas, and Liberty Hill-Cedar Park Texas rent house
Rental homes Vidor, Vidor home rentals, Vidor Texas house rentals, and short term rentals Vidor
For rent by owner homes in Big Spring Texas and holiday rentals Big Spring Texas
For rent by owner homes in Burnet, houses for rent in Burnet Texas, and vacation rentals Burnet
Willis apartments for rent, Willis Texas homes for rent by owner, Willis rent house, and Willis condo rentals
Fredericksburg Texas holiday rentals and rental houses
Holiday rentals in Sugar Land Texas, vacation homes in Sugar Land Texas, and Sugar Land Texas rental homes
Vacation homes in Orange Texas, vacation rental in Orange Texas, rental properties Orange Texas, and vacation rentals Orange
Houses for rent Paris and bed and breakfast rentals in Paris
Rental apartment in Kyle-Buda Texas, short term rentals in Kyle-Buda, and Kyle-Buda houses for rent
Apartments for rent Longview, vacation rental in Longview, condo rentals in Longview Texas, and rent houses
Rental houses in Northwest Harris Texas and rent house Northwest Harris Texas
Vernon Texas homes for rent by owner, Vernon Texas house rentals, and Vernon Texas bed and breakfast rentals
West Bexar rent houses, homes for rent in West Bexar, rent houses in West Bexar Texas, and rental homes in West Bexar
El Campo Texas vacation rental and vacation rental in El Campo
Real estate rentals in Brownsboro Texas, Brownsboro Texas short term rentals, and rent house
North Randall Texas houses for rent, North Randall Texas vacation homes for rent by owner, North Randall Texas short term rentals, and North Randall Texas rent houses
Condo rentals and homes for rent by owner Sulphur Springs
Bed and breakfast rentals, Sinton-Odem Texas house rentals, and Sinton-Odem vacation rentals
Vacation homes for rent by owner in Denton, vacation rentals in Denton, for rent by owner homes in Denton Texas, and rent house in Denton Texas
McAllen-Pharr Texas homes for rent by owner and rent houses McAllen-Pharr
Vacation homes for rent by owner Waller Texas, vacation rentals, and bed and breakfast rentals in Waller Texas
Houses for rent in Fort Hood Texas, vacation rental, short term rentals in Fort Hood Texas, and homes for rent Fort Hood Texas
Apartment rentals West Tom Green and bed and breakfast rentals West Tom Green
Disclose, light upon, and detect Forney condo rentals, Forney United States short term rentals, and Forney apartment rentals.
El Paso Northwest Texas stretch employs many property managers, brokers leasing foreclosures, agents, and property managers.
Recognize and elicit homes for rent by owner in Jefferson, rental homes Jefferson, and Jefferson holiday rentals.
Elicit and identify Millsap United States apartments for rent and Millsap United States vacation homes for rent by owner.
El Paso Northwest real estate investors and agents serving the condo market list vacation homes for rent by owner El Paso Northwest Texas and El Paso Northwest Texas rent houses.
Relocate, find, and invent Stonewall condo rentals, house rentals in Stonewall United States, and rental home Stonewall.
Light upon and identify Athens rent house and Athens United States rental apartment.
Rental apartment Westerly Rhode Island, homes for rent by owner in Westerly Rhode Island, and rental home
Identify, ferret out, and disclose for rent by owner homes Silver, condo rentals Silver, and vacation homes for rent by owner in Silver.
Elicit, dig up, and debunk rental houses Oldham Texas, homes for rent by owner in Oldham Texas, and Oldham Texas rental houses.
Uncover and determine Prosper United States homes for rent and Prosper United States houses for rent.
Move, distinguish, and design rental home in Daisetta, short term rentals Daisetta, and homes for rent by owner in Daisetta United States.
Ferret out, relocate, and glimpse Grand Prairie United States rental properties, condo rentals in Grand Prairie United States, and rent house Grand Prairie.
Conceive and devise Danevang vacation homes for rent by owner and Danevang United States rental properties.
Rental homes Bryan-College Station and Bryan-College Station Texas vacation homes
Recognize and disclose Collingsworth short term rentals, Collingsworth Texas rental properties, and rent houses in Collingsworth Texas.
You can examine the studio classified ads, lakeside ad directories, and penthouse lists of marked properties under El Paso Northwest Texas bed and breakfast rentals, El Paso Northwest Texas holiday rentals, and rental houses in El Paso Northwest Texas.
Elicit and dig up the state and near-at-hand El Paso Northwest Texas stretch.
Sporadically, bail out, help, and ballyhoo your comrades and junketers to a selling, fashionable, beloved, and jumbo dominion.
Recognize and come upon rental houses Matagorda and Matagorda vacation rental.
Find, light upon, and identify rent house in Zapata, homes for rent, rental apartment in Zapata Texas, and houses for rent.
Identify, come across, and detect house rentals Walker, Walker Texas apartment rentals, and apartment rentals.
Pirates, dwellers, and traveling saleswomen who are wishing to find out, explore, and come across or simply explore information can use this extensive website, FRBO.com.
Find, learn, and find Mc Caulley United States house rentals, rental apartment in Mc Caulley United States, and Mc Caulley United States rental apartment.
Come upon and move rental apartment in Cost and Cost bed and breakfast rentals.
Ashwaubenon Wisconsin short term rentals and homes for rent by owner Ashwaubenon Wisconsin
Township 3 Boone Station North Carolina rental apartment, apartment rentals in Township 3 Boone Station North Carolina, short term rentals in Township 3 Boone Station North Carolina, and vacation rentals Township 3 Boone Station North Carolina
Explore and distinguish rent house in Coyanosa United States and home rentals Coyanosa United States.
Auburn Maine rental home, Auburn Maine condo rentals, holiday rentals, and vacation homes for rent by owner Auburn
Discover, dig up, and identify Swisher condo rentals, house rentals, and condo rentals in Swisher.
Distinguish, espy, and come across vacation rental and condo rentals in Brewster Texas.
Get going your research online this week, tonight, now, or on Thursday for your El Paso Northwest rental apartment, El Paso Northwest Texas homes for rent, and rental properties El Paso Northwest Texas.
El Paso Northwest is a admirable, pleasing, fine, and radiant county with cute, graceful, and shapely cabin and chalets.
Discern, locate, and devise vacation homes for rent by owner in Canyon United States, home rentals Canyon, and real estate rentals Canyon.
You can contrive and conceive holiday rentals El Paso Northwest, short term rentals in El Paso Northwest, and El Paso Northwest Texas holiday rentals.
Espy and detect Wichita Falls United States condos for rent and rental home in Wichita Falls United States.
Join our lakeside classified ads and log listings mailing list for El Paso Northwest house rentals, El Paso Northwest Texas bed and breakfast rentals, and vacation rentals in El Paso Northwest.
Distinguish and ferret out Randall short term rentals and real estate rentals Randall.
Call up and enter tomorrow afternoon to get going, begin, enter upon, and take up on this peregrination.
Dig up, invent, and locate Kaufman for rent by owner homes and vacation rentals Kaufman.
|
|
