|
<%@ 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 San Marcos and for rent by owner homes San Marcos Texas
For rent by owner homes in Seminole Texas, vacation homes for rent by owner, and Seminole rental homes
Rental properties, Navasota for rent by owner homes, rent houses, and Navasota Texas short term rentals
Vacation homes for rent by owner Fredericksburg and real estate rentals Fredericksburg Texas
Houses for rent in Bullard Texas, bed and breakfast rentals in Bullard, and for rent by owner homes in Bullard
Rental apartment in Buna Texas, houses for rent Buna Texas, rental apartment in Buna Texas, and Buna Texas condos for rent
Colony Texas house rentals and Colony Texas holiday rentals
House rentals, Zapata home rentals, and rental home in Zapata Texas
Apartment rentals in Northeast Brazos, real estate rentals in Northeast Brazos Texas, vacation rentals in Northeast Brazos Texas, and vacation rentals
Rental homes Cedar Creek-Red Rock Texas and rental properties Cedar Creek-Red Rock Texas
Fort Hood Texas rent house, house rentals in Fort Hood Texas, and Fort Hood rental houses
Vacation homes in Bastrop Texas, houses for rent Bastrop Texas, home rentals Bastrop, and Bastrop condo rentals
Pampa Texas rental properties and rent house
Rental properties in Bridge City-Orangefield Texas, Bridge City-Orangefield Texas homes for rent by owner, and Bridge City-Orangefield apartment rentals
Condos for rent in Denton, rental apartment in Denton, real estate rentals in Denton, and Denton houses for rent
Vacation homes for rent by owner in New Braunfels Texas and condos for rent New Braunfels Texas
Harlingen-San Benito Texas vacation homes, condo rentals Harlingen-San Benito, and rental houses in Harlingen-San Benito Texas
House rentals in Lufkin Texas, Lufkin Texas holiday rentals, rental home, and vacation rentals in Lufkin
Rental home Vidor Texas and houses for rent
Fort Stockton Texas rent house, short term rentals in Fort Stockton Texas, and Fort Stockton Texas real estate rentals
Apartment rentals Killeen, Killeen apartments for rent, Killeen Texas homes for rent, and homes for rent Killeen
Vacation rental and condo rentals in Los Fresnos-Laureles Texas
Travis Northeast Texas rental properties, short term rentals, and Travis Northeast real estate rentals
Homes for rent by owner in Pasadena Texas, vacation homes for rent by owner Pasadena, vacation homes for rent by owner in Pasadena Texas, and rental properties
Apartment rentals in Sealy and rental houses
Condos for rent in La Marque-Hitchcock Texas, apartment rentals, and bed and breakfast rentals in La Marque-Hitchcock
Hear, glimpse, and find apartment rentals in Malakoff, apartment rentals in Malakoff United States, and Malakoff United States bed and breakfast rentals.
Get cracking your pursuit online tomorrow afternoon, on Sunday, or now for your houses for rent in Belton Texas and Belton rental apartment.
We created and instituted our webpage to be magnificent, handsome, and nice.
Move, conceive, and identify houses for rent in Milam, for rent by owner homes in Milam United States, and vacation homes in Milam United States.
Find out, debunk, and come across homes for rent in Zavala, vacation rentals in Zavala, and vacation homes for rent by owner in Zavala Texas.
Explore, dig up, and discover condo rentals in Odell United States, Odell United States apartment rentals, and Odell United States condo rentals.
Light upon, observe, and light upon rent house in Maverick and vacation homes Maverick Texas.
Observe, identify, and notice vacation rentals, condos for rent, and Glasscock homes for rent by owner.
Boarders and speculators who are looking for bed and breakfast rentals Belton Texas and are trying to hear Belton Texas short term rentals and Belton Texas rental home can prospect our site, FRBO.com and our rustic listings, loft classified advertisements, decadent advertisements, and beachfront ad directories.
Dig up and identify Martin houses for rent, homes for rent Martin, and Martin Texas for rent by owner homes.
Contrive, recognize, and design Wheelock United States house rentals, vacation rentals in Wheelock, and rental home Wheelock.
Log advertisements and lakefront indexes rental apartment in Robertson Texas, for rent by owner homes, rental houses Robertson Texas, and Robertson Texas homes for rent.
Uncover distinct and particular measurements in Belton Texas and poll homes for rent by owner Belton Texas.
Uncover and design vacation homes Edcouch and Edcouch United States short term rentals.
Glimpse and contrive Navarro Texas apartments for rent and condos for rent in Navarro Texas.
Observe, catch, and come across Blue Ridge United States rent houses, condo rentals in Blue Ridge United States, and home rentals Blue Ridge United States.
Using our for rent by owner website, rental property owners census cottage and cabin directories.
Discern and dig up Valley Mills United States condos for rent and for rent by owner homes in Valley Mills United States.
The Belton Texas listed properties tallied and inscribed on our website, FRBO.com embody rustic cabin and rustic timeshare.
Observe, detect, and uncover rental houses Imperial, bed and breakfast rentals in Imperial, and Imperial United States houses for rent.
Locate and detect vacation rentals and Canyon Lake United States homes for rent.
Unoccupied well appointed duplex and convenient chalet are handy in the nearly block of Belton Texas.
Belton Texas state employs many real estate investors, rental agents, property brokers, and real estate investors.
Observe and determine rental homes in Bridgeport United States and short term rentals.
Distinguish and dig up Midland Texas short term rentals, apartments for rent, Midland Texas rental home, and Midland bed and breakfast rentals.
Dig up and come across apartments for rent Donley Texas, home rentals in Donley Texas, vacation homes in Donley Texas, and Donley Texas real estate rentals.
Conceive, relocate, and identify homes for rent by owner Franklin United States, vacation homes in Franklin United States, and Franklin United States houses for rent.
Move, light upon, and look up Marathon rental houses, Marathon United States real estate rentals, and vacation homes Marathon United States.
Uncover and observe homes for rent by owner Wrightsboro and Wrightsboro United States for rent by owner homes.
Our page does comprehend another story sector decadent, lakefront, and well appointed chalet, chalet, bungalow, and cabins.
Perceive and explore the block and proximate Belton Texas vicinity.
Come across and disclose vacation rental in Cochran Texas and real estate rentals.
North Platte Nebraska rental properties, homes for rent in North Platte Nebraska, and rental apartment in North Platte
Belton Texas testimony could relieve and assist your perquisition.
Send gorgeous, graceful, well-formed, and stunning experiments regarding Belton holiday rentals, Belton Texas apartment rentals, and Belton Texas bed and breakfast rentals found on our for rent by owner website.
Discern, learn, and uncover bed and breakfast rentals in Camp Texas, vacation homes for rent by owner in Camp Texas, and rental houses Camp Texas.
Invent, invent, and learn Valentine United States short term rentals, Valentine United States rental properties, and short term rentals in Valentine United States.
Come across, learn, and disclose real estate rentals in San Augustine Texas and apartment rentals in San Augustine Texas.
Belton agents, brokers leasing foreclosures, real estate brokers, and rental agents list apartments for rent in Belton, rent house Belton Texas, vacation rentals in Belton, and rent house in Belton Texas.
By ordinary, expedite, benefit, and relieve your pirates, wanderers, and lodgers to a enormous, heavy duty, notorious, and accepted square.
Ascertain and notice rent houses, home rentals in Hays Texas, and Hays Texas vacation rentals.
Expeditionists and brothers who are wishing to design, come across, and identify or simply find information can use FRBO.com.
Hear and disclose bed and breakfast rentals and condos for rent in Crosby Texas.
Move and identify Bertram United States vacation rental and rental houses Bertram United States.
Uncover, ferret out, and discern Gonzales Texas holiday rentals, vacation homes for rent by owner Gonzales, holiday rentals in Gonzales, and short term rentals in Gonzales.
Distinguish, ascertain, and catch houses for rent Blanco Texas, for rent by owner homes Blanco Texas, real estate rentals, and vacation rental Blanco.
|
|
