Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T17:07:46.150' ,`MLSNumber` = '27451901' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943236' ,`Longitude` = '-95.689253' ,`PhotoCount` = '34' ,`PostalCode` = '77433' ,`RoomCount` = '14' ,`ListPrice` = '949990.00' ,`Status` = 'Active' ,`StreetName` = 'Brazos River' ,`StreetNumber` = '18003' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HX6814 - Located on a cul-de-sac street in the desirable Towne Lake community, this beautiful home boasts a brick and stacked stone elevation. Enter through elegant front door into the stunning entry complemented by a spiral staircase, wood floors and a soaring ceiling. Adventuring further into the home, you will appreciate the open concept design. Enjoy entertaining in the family room graced with 19-foot ceilings, while the chef of the family prepares everyone’s favorite dish in the gourmet kitchen. Equipped with an oversized island that overlooks the family room and breakfast nook, conversation easily flows in this space. Additionally, the kitchen hosts painted custom cabinetry, a stainless steel double oven appliance package, stylish pendant lights and gleaming granite countertops. Take your culinary creations to the covered patio through the sliding glass doors and enjoy views of the large backyard. Complete with a 4-car garage, this home has many luxurious features to appreciate.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 1' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11853' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1674' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '' ,`TaxRate` = '3.6' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266015' WHERE `Matrix_Unique_ID` = '201312188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T18:07:49.133' ,`MLSNumber` = '64832043' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220451' ,`Longitude` = '-95.712027' ,`PhotoCount` = '16' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '689900.00' ,`Status` = 'Active' ,`StreetName` = 'Ringbill' ,`StreetNumber` = '15467' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perry Homes New Construction! Welcoming entry framed by home office with French doors. Entry extends past the formal dining room. Wood flooring throughout main areas. Open family room with a wall of windows and a wood mantel fireplace. Center island kitchen with built-in seating space, a 5-burner gas cooktop, double wall oven and a walk-in pantry. Morning area just off the kitchen. Secluded primary suite with a wall of windows. Primary bath offers dual vanities, garden tub, separate glass enclosed shower, a linen closet and two walk-in closet. Game room with French door entry just off the family room. Private guest suite with a full bathroom and a walk-in closet. Secondary bedrooms and a utility room completes this design. Extended covered backyard patio. Mud room just off the three-car garage.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S221803 - Audubon Park 03, BLOCK 1, Lot 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9472' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266015' WHERE `Matrix_Unique_ID` = '202482502' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T18:07:49.133' ,`MLSNumber` = '31172791' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293647' ,`Longitude` = '-95.558033' ,`PhotoCount` = '21' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '519900.00' ,`Status` = 'Active' ,`StreetName` = 'Mistletoe Ridge' ,`StreetNumber` = '318' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2797' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors and formal dining room set at two-story entry. Kitchen and morning area open to two-story family room with wall of windows and a wood mantel fireplace. Kitchen features corner walk-in pantry, 5-burner gas cooktop and generous island with built-in seating space. First-floor primary suite. Dual vanity, garden tub, separate glass-enclosed shower and large walk-in closet in primary bath. A second bedroom is downstairs. Upstairs features a game room and two secondary bedrooms. Extended covered backyard patio. Mud room off two-car garage.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965285 - Woodforest 85, BLOCK 1, Lot 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '2.9' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266015' WHERE `Matrix_Unique_ID` = '202592639' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T17:07:46.150' ,`MLSNumber` = '94297496' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398535' ,`Longitude` = '-95.504790' ,`PhotoCount` = '28' ,`PostalCode` = '77318' ,`RoomCount` = '13' ,`ListPrice` = '564983.00' ,`Status` = 'Active' ,`StreetName` = 'Lontano Path' ,`StreetNumber` = '478' ,`StreetSuffix` = 'Loop' ,`City` = 'Willis' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2853' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-in Ready! Westin Homes NEW Construction (Grayson, Elevation C) One story. 4 bedrooms. 3.5 bathrooms. Family Room, Informal Dining room and Study. Spacious island kitchen open to living area. Master suite with large double walk in closets. Covered patio and attached 3 car tandem garage. The Woodland Hills is located 13 miles north of The Woodlands in Conroe and Willis, Texas. It is a 2,000-acre forested master planned community, featuring 112 acres of open space, 20 neighborhood parks, a 17-acre Village Park and an activity center with event space and fitness facility. The community will also include an extensive amount of trails for hiking and biking in addition to dedicated bike lanes. Stop by the Westin Homes model to learn more about The Woodland Hills!' ,`Acres` = '0.2979' ,`Area` = '39' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 1, LOT 26' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12976' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '1944' ,`TaxRate` = '3.3524' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266016' WHERE `Matrix_Unique_ID` = '205000615' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T17:07:46.150' ,`MLSNumber` = '91990061' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220738' ,`Longitude` = '-95.710765' ,`PhotoCount` = '48' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '545000.00' ,`Status` = 'Active' ,`StreetName` = 'Ringbill' ,`StreetNumber` = '15498' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Empire Communities -Estimated August 2022 completion! This home is located in Magnolia in a beautiful architectural community called Audubon. This community will include future schools, churches, forested environments, creeks, walkable parks and trails. The best time to visit and make this home yours is now. You will fall in love with the gorgeous open-concept Eastland floorplan. Modern farmhouse inspired w/light brick & dark accents on the garage and trim. Enter through your grand foyer with high ceilings that continue through the great room. The open kitchen & living space offers tons of natural light & plenty of room for entertaining. The 1st floor boasts the primary bedroom & a office ! Enjoy a spacious game-room upstairs. With upscale finishes such as built-in GE stainless steel appliances, quartz countertops, trendy cabinets, vinyl plank wood flooring, covered patio & convenient access to nearby dining, shopping & schools, this home truly has it all!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 4 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266016' WHERE `Matrix_Unique_ID` = '205033511' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T17:07:46.150' ,`MLSNumber` = '40891022' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220640' ,`Longitude` = '-95.713491' ,`PhotoCount` = '35' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '490000.00' ,`Status` = 'Active' ,`StreetName` = 'Parkside Oaks' ,`StreetNumber` = '40027' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Empire Communities -Estimated August 2022 completion! This home is located in Magnolia in a beautiful architectural community called Audubon. This community will include future schools, churches, forested environments, creeks, walkable parks and trails. The best time to visit and make this home yours is now. You will fall in love with the gorgeous open-concept Burleson floorplan. Modern farmhouse inspired w/light brick & dark accents on the garage and trim. Enter through your grand foyer w/18\' ceilings that continue through the great room. The open kitchen & living space offers tons of natural light & plenty of room for entertaining. The 1st floor boasts the primary bedroom & a secondary bedroom, perfect for guests! Enjoy a spacious upstairs loft. With upscale finishes such as built-in GE stainless steel appliances, quartz countertops, trendy cabinets, vinyl plank wood flooring, covered patio & convenient access to nearby dining, shopping & schools, this home truly has it all!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 3 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Audubon' ,`TaxAmount` = '' ,`TaxRate` = '3.3087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266016' WHERE `Matrix_Unique_ID` = '205037189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T18:07:49.133' ,`MLSNumber` = '64166893' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398504' ,`Longitude` = '-95.499532' ,`PhotoCount` = '30' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '721900.00' ,`Status` = 'Active' ,`StreetName` = 'Calm Savanna' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perry Homes New Construction! Entry and extended entry with 13-foot ceiling. Home office with French doors. Game room with French doors. Kitchen features a large pantry and a large island that has a built-in seating space, 5-burner gas cooktop and a double wall oven. Open dining area with a wall of windows. Open family room with a cast stone fireplace and a wall of windows. Private primary suite with a wall of windows. Double doors lead to primary bath with separate vanities, garden tub, separate glass enclosed shower and two walk-in closets. Extended covered backyard patio. Mud room leads to 3-car garage.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S927100 - The Woodlands Hills 01, BLOCK 1, Lot 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12730' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266016' WHERE `Matrix_Unique_ID` = '205085920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T18:07:49.133' ,`MLSNumber` = '16345081' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398504' ,`Longitude` = '-95.499532' ,`PhotoCount` = '31' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Calm Savanna' ,`StreetNumber` = '219' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perry Homes New Construction! French door entry with 13-foot ceiling framed by home office with French doors. Formal dining room just off the extended entry. Island kitchen with walk-in pantry, a 5-burner gas cooktop and a double wall oven. Spacious family room with wall of windows, wood mantel fireplace and 12-foot ceiling. Morning area adjacent to game room with wall of windows. Secluded primary suite with 11-foot ceiling and a wall of windows. French door entry to the primary bath with dual vanities, a garden tub, separate glass enclosed shower and two walk-in closets. Secluded guest suite with a full bathroom and walk-in closet. Extended covered backyard patio. Mud room just off the three-car garage.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S927100 - The Woodlands Hills 01, BLOCK 1, Lot 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11756' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266017' WHERE `Matrix_Unique_ID` = '205086111' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T18:07:49.133' ,`MLSNumber` = '85823132' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.292363' ,`Longitude` = '-95.565542' ,`PhotoCount` = '20' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '539900.00' ,`Status` = 'Active' ,`StreetName` = 'Sky Top' ,`StreetNumber` = '282' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2999' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at two-story entry. Open kitchen hosts inviting island with built-in seating space and a 5-burner gas cooktop. Two-story dining area opens to two-story family room with wall of windows and a wood mantel fireplace. First-floor primary suite with wall of windows. Dual vanities, garden tub, separate glass-enclosed shower and two walk-in closets in primary bath. A guest suite with full bath is downstairs. Secondary bedrooms, a game room and media room with French doors are upstairs. All bedrooms include walk-in closets. Covered backyard patio. Mud room off three-car garage.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965281 - Woodforest 81, BLOCK 1, Lot 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6150' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '2.83' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266017' WHERE `Matrix_Unique_ID` = '205094143' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T18:07:49.133' ,`MLSNumber` = '73903366' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.221752' ,`Longitude` = '-95.750882' ,`PhotoCount` = '29' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '631872.00' ,`Status` = 'Active' ,`StreetName` = 'Running Iron' ,`StreetNumber` = '634' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2667' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This incredible Beazer Home located on an oversized lot in Timber Hollow has it all, featuring a brick façade, luxury vinyl plank flooring, a 2-car side load garage with additional detached single-car garage, wrought iron spindles, a study with French doors, and an extended covered patio. Master new recipes in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, huge refrigerator, 36” cooktop, stainless steel appliances, and 42” upper cabinets, pendant lighting, and under-counter lighting. Residents of Timber Hollow enjoy a 9-acre lake, rolling hills, and walking trails. Commuters enjoy the ease of access to HWY 249 and the Grand Parkway. Schools are zoned to the Magnolia ISD. Don’t miss this home – call now to learn more!' ,`Acres` = '0.351' ,`Area` = '15' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 Block 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Hollow' ,`TaxAmount` = '' ,`TaxRate` = '3.36' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266017' WHERE `Matrix_Unique_ID` = '205342069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T17:07:46.150' ,`MLSNumber` = '17777069' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691176' ,`Longitude` = '-95.930404' ,`PhotoCount` = '9' ,`PostalCode` = '77441' ,`RoomCount` = '7' ,`ListPrice` = '633900.00' ,`Status` = 'Active' ,`StreetName` = 'Southpoint Way' ,`StreetNumber` = '30507' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set entry. Media room with French doors off extended entry. Formal dining room flows into open family room with wall of windows and a fireplace. Kitchen features corner walk-in pantry and generous island with built-in seating space. Adjoining morning area features wall of windows. Primary suite includes double-door entry to primary bath with dual vanities, garden tub, separate glass-shower and two walk-in closets. Guest suite offers private bath. High ceilings and abundant closet space add to this spacious four-bedroom design. Extended covered backyard patio. Mud room off three-car garage.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Fulbrook on Fulshear Creek Lot 18, Blk 2, Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8060' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook on Fulshear Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.9' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266017' WHERE `Matrix_Unique_ID` = '205426693' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T17:07:46.150' ,`MLSNumber` = '14129776' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564266' ,`Longitude` = '-95.755809' ,`PhotoCount` = '38' ,`PostalCode` = '77469' ,`RoomCount` = '11' ,`ListPrice` = '699990.00' ,`Status` = 'Active' ,`StreetName` = 'Ruby Ford' ,`StreetNumber` = '1531' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home\'s beautiful elevation and fantastic curb appeal are sure to grab your attention. Welcome to one of Coventry Homes’ best-selling floor plans. The stunning double front door are sure to impress as you enter the foyer. The kitchen comes equipped with an oversized island that overlooks the family room and dining area. With this set-up, entertaining guests will be a breeze. The game room and media room offer ample amounts of additional entertaining space. The spacious Texas-sized covered back patio completes the home. Come and see this home today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot 18 block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8450' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '990' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '2.86' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266017' WHERE `Matrix_Unique_ID` = '205689043' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T18:07:49.133' ,`MLSNumber` = '87826624' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.277986' ,`Longitude` = '-95.534321' ,`PhotoCount` = '19' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '689900.00' ,`Status` = 'Active' ,`StreetName` = 'Carverna' ,`StreetNumber` = '511' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Front porch. Home office with French doors frames the two-story entry. Island kitchen features a large pantry, 5-burner gas cooktop, built-in seating space and opens to the morning area. Two-story family room features 19-foot ceilings, a wood mantel fireplace and a wall of windows. Private primary suite with a wall of windows. Primary bath features dual vanities, garden tub, a separate glass enclosed shower and two large walk-in closets. Game room, media room and secondary bedrooms including a guest suite complete the second level. Extended covered backyard patio. Three-car garage.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965306 - Woodforest 106, BLOCK 1, Lot 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9568' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '2.84' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266018' WHERE `Matrix_Unique_ID` = '205698079' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T18:07:49.133' ,`MLSNumber` = '68332377' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.188207' ,`Longitude` = '-95.418195' ,`PhotoCount` = '21' ,`PostalCode` = '77515' ,`RoomCount` = '6' ,`ListPrice` = '295282.00' ,`Status` = 'Active' ,`StreetName` = 'Kelly' ,`StreetNumber` = '120' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Riverwood Ranch! Anglia Homes presents the Newmarket. This is a two-story home is a 3 bedroom 2.5 bathroom with a 2 car attached garage. The rooms are upstairs and spacious! Schedule your appointment today and come see this beautiful home and make it yours!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 35, Block 1, Section 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverwood Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266018' WHERE `Matrix_Unique_ID` = '205783305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T18:07:49.133' ,`MLSNumber` = '33138229' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.161399' ,`Longitude` = '-95.193927' ,`PhotoCount` = '19' ,`PostalCode` = '77357' ,`RoomCount` = '8' ,`ListPrice` = '529900.00' ,`Status` = 'Active' ,`StreetName` = 'Timbarra Glen' ,`StreetNumber` = '23450' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set entry. Media room with French doors off extended entry. Formal dining room flows into open family room with wall of windows and a wood mantel fireplace. Kitchen features corner walk-in pantry, double wall oven, 5-burner gas cooktop and generous island with built-in seating space. Adjoining morning area features wall of windows. Primary suite includes double-door entry to primary bath with dual vanities, garden tub, separate glass-shower and two walk-in closets. Guest suite offers private bath. High ceilings and abundant closet space add to this spacious four-bedroom design. Covered backyard patio. Mud room off three-car garage.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Block 3' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8727' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '' ,`TaxRate` = '3.39' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675266018' WHERE `Matrix_Unique_ID` = '205905172' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T17:07:46.150' ,`MLSNumber` = '67694603' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.220883' ,`Longitude` = '-95.712402' ,`PhotoCount` = '5' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '674900.00' ,`Status` = 'Active' ,`StreetName` = 'Ringbill' ,`StreetNumber` = '15476' ,`StreetSuffix` = 'Way' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3322' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perry Homes New Construction! Welcoming entry with 14-foot ceilings framed by Home office with French doors. Formal dining room with a wall of windows just off the family room and kitchen. Large family room with a grand wall of windows and a wood mantel fireplace. Corner island kitchen offers a large walk-in pantry, double wall oven and a 5-burner gas cooktop. Kitchen opens to a dedicated morning area. Game room with French door entry and a wal